Ten Minute Guide to Access 97

Adding Criteria

Criteria will be familiar to you if you read Lesson 18, which deals with filters. Criteria enables you to choose which records will appear in your query results. For example, I could limit my list of dogs to those whose birth dates were before 8/5/94.

Filters versus Queries

If the primary reason for creating the query is to filter, you may want to create the filter part first using one of the procedures described in Lesson 18, and then you can save the filter as a query. You can open that query in Query Design view and fine-tune it as needed.

To set criteria for a field that you've added to your query, follow these steps:

1. In Query Design view, click the Criteria row in the desired field's column.

2. Type the criteria you want ...