I have a database and I have a form with a Calendar control that users click to populate 2 text boxes. The form's control source is set to a query with the following code
SELECT count (*) AS RangeCount
WHERE iDate between Forms!RangeQueryForm!Date1 And
The table has records with dates from Nov 1 thru Nov 12, if I run the query on [for example] NOv 2 thru Nov 12, it returns the count total for Nov 2 and Nov 12 only and skips the dates in between
Can someone tell me what I am doing wrong?