date parameter in query not working quite right

B

Bongard

Hi I have a Query [qry_master] which contains a field [notedate] I want
the user to be able to specify an as of date and I want that as of date
to include the date that they specify. Currently in my fields criteria
line I have

<=[Enter an As Of Date]

But when the query runs it never included the entered dates
information. Does anyone have any ideas why this might be?

Thanks!
Brian
 
R

Rick Brandt

Bongard said:
Hi I have a Query [qry_master] which contains a field [notedate] I
want the user to be able to specify an as of date and I want that as
of date to include the date that they specify. Currently in my fields
criteria line I have

<=[Enter an As Of Date]

But when the query runs it never included the entered dates
information. Does anyone have any ideas why this might be?

Thanks!
Brian
Click to expand...

If your data includes times other than midnight then a "date only" search
will only find records where the time is exactly midnight on that day. Try
this instead...

< DateAdd("d", 1, [Enter an As Of Date])
 
Top