Query Prompts for Parameters??

[jennuhw]

Is there a way to have a query prompt for parameters when opening?

 

[lode]

Please be a little bit more specific.

 

[jennuhw]

I want a query to prompt for the date parameter (equals) when someone opens it up. This way they don't have to edit the query before opening it. Everything else is to stay the same except for the date.

 

[doneitagain]

You need to put the prompt in square brackets in the criteria section of the query (if using Access).

eg. [Please input the date.]

(In Microsoft Query in Excel the prompt goes in the value section)

When you run the query it will prompt for the date.

Hope this helps

 

[jennuhw]

Thank you very much! It works!