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.

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).

--
HTH
Van T. Dinh
MVP (Access)



"Kevin76" <(E-Mail Removed)> wrote in message
news:208EE1F6-2DEB-45A1-B392-(E-Mail Removed)...
>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.