Home > Sample chapters > Microsoft Office > Access

Creating Queries in Access 2010

Using Criteria to Focus Query Results

It’s unlikely that you’ll want your query to find every record in a table—if you did, you could just open the table and not bother with the query! To limit the records a query locates, such as finding customers only in Germany, you can add criteria to the fields in the Query design grid.

Set Query Criteria

  1. Open a query in Design view.

  2. Click the Criteria cell for the field to which the criterion will be applied.

  3. Click Builder.

  4. Create the criterion in the Expression Builder.

  5. Click OK.

    httpatomoreillycomsourcemspimages613730.jpg