field.
For many examples of query criteria for various data types, see the article Examples of query criteria.
Specify any alternate criteria in the Or row, below the Criteria row.
If you specify alternate criteria, a field value can meet any of the listed criteria and be included in the query result.
Multiple field criteria
You can use criteria with multiple fields. When you do, all the criteria in a given Criteria or Or row must be true for the record to be included.
Specify criteria by using a field that you don't want to output
You can add a field to your query design and not include the field's data in the query output. You do this if you want to use the field's values to limit the query results, but don't want to see the field values.
Add the field to the design grid.
Clear the check box in the Show row for the field.
Specify criteria as you would for an output field.
Step 5: Summarize data
This step is optional.
You might want to summarize data, especially if your data is numeric. For example, you might want to see the average price, or total sales.
To summarize data in a query, you use the Total row. By default, the Total row is not displayed in Design view.
With the query open in Design view, on the Design tab, in the Show/Hide group, click Totals.
Access displays the Total row in the query design grid.
For each field that you want to summarize, choose the function to use from the list in the Total row. The functions that are available depend on the data type of the field.
To learn more about the Total row functionality in queries, see the article Sum or count values on a datasheet with a Total row.
Step 6: View the results
To see the query results, on the Design tab, click Run. Access displays the results of your query in Datasheet view.
To make further changes to the query, click Home > View > Design View to switch back to Design view.
Change your fields, expressions, or criteria and rerun the query until it returns the data that you want.