parameters in access query

[jazzgirl]

I am working with an Access 2007 query where part of the selection criteria is a start and end date. I have this hard coded in the query.

Is there a way to supply a start and end date to an access 2007 query using paramters that can be entered by the user? If this is possible can you tell me and/or point me to a url that explains how to supply parameters to an access query?

 

[vbbbmom]

Try this, open the query in design view, in the criteria for the date type the following:

between [enter start Date] and [enter end date]

Then run the query, you should see two prompts one right after the other, the first will ask for Start Date and the second will ask for the End date.