I can't seem to figure out how to get an inclusive range of dates in a query when the date field is in the "date/time" format (DD/MM/YYYY TT:TT AM). When I create a query that has a criteria of "Between [StartDate] And [EndDate]" It will not include the date entered for EndDate. For example, when I run the query and enter "10/20/03" for StartDate and "10/20/03" for EndDate, I get no records returned. However, if I enter "10/20/03 00:00 AM" for StartDate and "10/20/03 23:59 PM" for EndDate, I get all the records for 10/20/03 returned.
My question is:
How can I get the query to return an inclusive range of dates without having to type in a range of times as well?
Try formating the date field range in the query. Right click on the Field you are querying and format it using shortdate. 11/05/2003. Then your request as between #11/05/2003# and #11/05/2003#. If I can suggest if your end date and started are not the same, you are requesting all records that meet both criterias. Search by one criteria and then check your results.
Thanks. I tried that but still can't get the results to be inclusive unless I include the time along with the date. I formatted the date field as short date. I even formatted the field in the table the query is pulling the data from with short date. It still won't include the EndDate in the results. Frustrating!