Master Creating Advanced Filters in 2 Minutes

Access 2016

In this week’s lesson, learn how to create an advanced filter in Access 2016. An advanced filter is the most powerful of Access’s filters and is used to sort multiple fields, use complex filter criteria and expressions, and multiple AND OR statements.

Create an Advanced Filter

Access’s most powerful type of filter is the Advanced Filter, which is used to sort multiple fields, use complex filter criteria and expressions, as well as use multiple AND OR Statements. Advanced Filters have many advantages. They have the ability to:

  • Sort by multiple fields: You can sort records using several fields. For example, you could sort a table alphabetically by last name and then by first name.
  • Use complex filter criteria and expressions: You can use advanced expressions and operators to search for data. For example, you could filter for dates that fall Between 1/1/95 And 12/31/99.
  • Use multiple AND/OR statements: You can use more than one criterion to sift through records. For example, you could filter for employees who are from Washington AND who have been with the company for more than five years.
  1. Open the table that contains the data you want to filter or sort and click the Advanced Filter Options button.

  2. Select Advanced Filter/Sort.

  1. Double-click each field you want to include from the field list.

    Note: You can also drag fields from the field list onto the design grid to add fields or click the list arrow in the Field row of the design grid and select a field.

  2. Click the Sort list arrow for the field and select a sort order (optional).

  1. Enter any desired search criteria for the fields in the Criteria row.

  2. Click the Apply Filter button.

    The Advanced filter is applied.