how to make a query ask for date

[CFP - Jason]

i wanna run a query for employee activity on a certain day. how do i make the query ask what day to use? btw i have it made already, it just shows all the dates, i just want one at a time.
Thanks
Jason

 

[jeremie_ingram]

In the criteria area for the queries date field put this

[Please enter a date]

This will change you regular Select query into a parameter query, and every time it is opened it will prompt for input from the end user. Whatever you place between the brackets will appear in a pop up message box with an input field for the users. Only problem, if theres no match, it comes back blank.

If you cannot run the risk of it coming back blank, create another form that lists all availible dates in a combo box. Once they select a data, you can trigger the query and use the selection in as the parameter.