Creating Queries in Access 2010
- 6/15/2010
- Introducing Query Types
- Creating a Query Using the Query Wizard
- Editing a Query in Design View
- Using Criteria to Focus Query Results
- Introducing Operators
- Using Queries to Calculate Values
- Creating a Parameter Query
- Finding Duplicate Records
- Finding Unmatched Records
- Writing Query Results to a New Table
- Creating an Update Query
- Creating a Crosstab Query
- Finding the Largest and Smallest Values in a Field by Using a Query
Creating a Parameter Query
Some of the time, you can create a query that always looks for the same information, such as orders from a specific country or the total orders from an established customer. Other times, however, you and your colleagues need the flexibility to enter a criterion (such as a country) into the query to focus the results correctly. You can do that by creating a parameter query, which lets you specify the criterion the query uses to find records.
Build a Parameter Query
Open a query in Design view.
Type the prompt surrounded by square brackets in the Criteria cell in the column representing the field in which you want to find the entered value.
Click Run to test the query.
Type a value in the message box that appears.
Click OK.
CAUTION
If you don’t type a prompt between the square brackets, the only indication you get to enter a parameter is a blank dialog box. If someone unfamiliar with the database runs the query, he or she will have no idea what to type in the box.