Filter records by using the Advanced Filter/Sort window

1. Open a table, query, or form in Datasheet view or open a form in Form view.
   
   
2. Click in the datasheet, subdatasheet, form, or subform you want to filter.
   
   
3. On the Records menu, point to Filter, and then click Advanced Filter/Sort.
   
   
4. Add to the design grid the field or fields you'll need to specify the values or other criteria the filter will use to find records.

   How?

5. To specify a sort order, click in the Sort cell for a field, click the arrow, and select a sort order.

   Microsoft Access first sorts the leftmost field in the design grid, then it sorts the next field to the right, and so on.

6. In the Criteria cell for the fields you have included, enter the value you're looking for or enter an expression.

   For more information on entering criteria, click .

7. Apply the filter by clicking Apply Filter on the toolbar.

Notes

• When you save a table or form, Microsoft Access saves the filters. You can reapply the filters when you need them, the next time you open the table or form.
  
  
• When you save a query, Microsoft Access saves the filters you created, but it does not add the filter criteria to the query design grid. You can reapply the filters after you run the query, the next time you open it.
  
  
• If you created a filter on a subdatasheet or subform, this filter is also available when you open the table or form for the subdatasheet or subform independently.
  
  
• For information on creating a form or report based on the filtered data, click .
  
  
• Instead of creating a filter from scratch, you can use an existing query as a filter. For more information, click .