View Single Post
  #4  
Old April 30th, 2010, 10:14 PM posted to microsoft.public.access.queries
Marshall Barton
external usenet poster
 
Posts: 5,361
Default Using Between...And with General Date

mewins wrote:

I am trying to query all records created between given dates. The field,
DtRecCrt, is a general date field that is set to =Now() whenever the records
are created. However, when I run the query and have the criteria for
DtRecCrt set to "between [start date] and [end date]," it will return records
up to but not including the end date specified. How do I make the query
include records created on the end date?


That's to be expected because the time part from Now is
after the time part (midnight) in [end date].

To deal with that change your criteria to:
=[start date] And DateAdd("d", 1, [end date])

--
Marsh
MVP [MS Access]