Date Parameter for Now() field

[Guest]

I have a table where the date field is Now() providing the date and time of
each record. I tried to query it using a date as the parameter [Enter Date]
but it does not find any records. When I do for example Like "10/10/2006*" I
get the results I want. Now how do I turn that into a parameter so it will
ask me to enter the date each time and be programmed to do the like thingy.

 

[Van T. Dinh]

a datetime value with non-zero time component is NOT equal to date-only
value!

You need to use Between to select a range or more accurately greater than /
equal operator and less than operator like:

([DateField] >= [Enter Date]) AND
([DateField] < DateAdd("d", 1, [Enter Date]))

(typed as 1 line in the criteria row of your Query grid).