Show All

Limit the records you retrieve by using criteria

You can retrieve specific records by using criteria. Microsoft Query uses your criteria to retrieve the records you want and displays them in the result set. To limit the records you retrieve, you can select a value in the result set and then find other records that match that value. Or, you can create specific criteria in the Criteria pane and then retrieve records that meet only that criteria.

What do you want to do?

Learn about using criteria

Retrieve records that match a specific value

Specify what records to retrieve by using criteria

See examples of expressions you can use as criteria