You can add field criteria to your query by typing them into the query’s Criteria and Or cells.
To add field criteria to a query
1.Double-click the Criteria cell for the field.
2.Type the desired criteria.
For example, in the graphic above =1 has been entered into the Criteria cell for the CategoryID field. If you then click the Run Query button, you will only see the records where the CategoryID field equals 1:
You can add more than one piece of criteria for a field by typing into the Or cells:
If you click the Run Query button after entering the pieces of criteria shown above, you will see all the records where the CategoryID field equals 1 or equals 3:
You can also add criteria for more than one field:
If you click the Run Query button after entering the pieces of criteria show above, you will see all the records where the CategoryID field equals 1, or the CategoryName field equals Ink Cartridge and Refills: