Query criteria helps you to retrieve specific data from your database.
If an item matches with all the criteria you enter, it will appear in the query results.
When you want to limit the results of a query based on the values in a field, you use query criteria.
In this example, we are going to search for employees who live in Leicester.
Find the City field and the criteria box. Type in Leicester as the search criteria.
Click on the command to run the query and see the results.
Print out this Page
AND & OR Criteria