Dates in parameter query

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

I cannot find how to include all dates in Between And
criteria. I know it has to do with Date/Time feature but
how do you get around the time part on entering dates.
 
Dave,
If you do not need the time portion in the date field, don't enter
it when you enter data into the field, i.e. use Date() as default
instead of Now(), and you wouldn't have this problem.

Using:
Between [Enter Start Date] and [Enter End Date]
To find records between 9/1/2003 and 9/27/2003:

1) If the field has a time value, then you need to add one day to the End
Date:
enter
9/1/2003 and 9/28/2003.

Or..
2) Enter a time value with the end date, such as
9/27/2003 23:59:59
 
Back
Top