Home > Sample chapters > Microsoft Office > Access

Creating Queries in Access 2010

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

  1. Open a query in Design view.

  2. 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.

  3. Click Run to test the query.

  4. Type a value in the message box that appears.

  5. Click OK.

    httpatomoreillycomsourcemspimages613736.jpg