Create a Parameter Query
If instead of entering predetermined criteria, you want to prompt users when a query runs, you can create a parameter query. You create a parameter query by enclosing a question in square brackets ([]). For example, if you want to create a parameter query that asks users which State they want to use from the Student’s table, you would type [Which State?] on the Criteria line under the State column. When the query runs, Access will prompt the user for the answer to your question.To create a parameter query:
1. Open a table or query in Query Design view.
2. Create your query.
3. On the Criteria line, type the prompt within square brackets.
4. Click the Run button. Access prompts you.
Post a Comment