query help 1

[angels2]

I am running a query containing several dates in one field I put the date criteria in the query and receive the answer for that date. I would like to create a date input option in the query instead of editing. I want to run the query and hve a popup box to type in date then run the query for a single day.

 

[PHV]

In the criteria cell:
=[Enter the date]

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[angels2]

Thank you worked just like I wanted