Enter criteria in a query or advanced filter to retrieve certain records

To learn more about using criteria, click .

1. Open a query in Design view, or display the Advanced Filter/Sort window for a table, query, or form.
   
   
2. Click the first Criteria cell for the field you want to set criteria for.
   
   
3. Enter the criteria expression by typing it or by using the Expression Builder. To display the Expression Builder, right-click in the Criteria cell, and then click Build. For more information on using the Expression Builder, click .

   

   If your query includes linked tables, the values you specify in criteria on fields from the linked tables are case-sensitive — they must match the case of the values in the underlying table.

   When you view a subdatasheet in a query, the Advanced Filter/Sort window contains the record source only for the selected subdatasheet. To filter on fields contained in the main datasheet or in a different subdatasheet, close the Advanced Filter/Sort window, select the main datasheet or the subdatasheet on which you want to set filter criteria, and then reopen the Advanced Filter/Sort window.

4. To enter another expression in the same field or in another field, move to the appropriate Criteria cell and enter the expression.

Notes

• For examples of criteria expressions, click .
  
  
• For information on where to enter criteria in a query that performs calculations, click .