Date query in Access

[outbackut]

How do I enable a query to prompt a user for a date, which will retrieve all records with that date in the database? I think I have to put something on the Criteria line, but I am not sure what.

Thanks.

 

[Netooi]

First, make your query putting in the fields you need to return.

Then, in query design, right-click and select parameters
Add a date/time field called "MyDate" or whatever you want to name it..

then set the Criteria field to be
[MyDate]

if you should need the query to return less than or greater than the date entered just change the criteria to
< [MyDate] or
> [MyDate]

That should take care of it.
Netooi

 

[outbackut]

Thanks for the information.