Query Criteria

Diving Line

If you need to print this page out, type your name in the box below.

Your Name : 


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 Databases command to run the query and see the results.

PrintIT  Print out this Page

Next  AND & OR Criteria

Last modified: Monday, 7 December 2020, 3:00 PM