Use criteria to get the most specific information from a query. (Get the basics from, introduction to queries.)
In the example below, criteria added to the Country/Region field returned a specific list of results.
-
Open your query in Design view.
-
In the query design grid, click the Criteria row of the field where you want to add the criterion.
-
Add the criteria and press ENTER.
You can use several types of criteria like text, dates (read about applying criteria to text and using dates as criteria) and functions.
-
Click Run to see the results in Datasheet view.
When you need to add multiple types of criteria, you can use the OR row and also add criteria rows. Take a look at some examples of query criteria to help you get started in creating your own query criteria. Since criteria are a kind of expression, it might be more helpful to get more information about expressions.
