If you find yourself changing the criteria for the same query over and over, you may wish to convert your query into a Parameter Query. Instead of manually entering the criteria, a Parameter Query prompts the user for the criteria before the query is run. For example, you could create a Parameter Query to view orders for different states, rather than having to write a separate query for each state. When the query is run, the user receives a custom message, such as “Please Enter a State.” The data the user enters is then applied as the query’s criteria.
To create a Parameter Query, click in the Criteria cell of the desired query column and then type the message, enclosed in brackets, that you want the user to receive when the query is run. Access will then display to the user a parameter prompt that contains the text of the parameter expression that you entered in the Criteria row.
To Create a Parameter Query
1. Create a new query in design view.
2. Click in the Criteria row of the field to which you wish to add a parameter expression.
3. Type the message, enclosed in brackets, that you want to appear to the user.