Using Criteria to Focus Query Results

It’s likely you won’t 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 only finding customers 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 ...

Get Microsoft® Office Access™ 2007 Plain & Simple now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.