Filter by Selection

How to Filter by Selection in Access

Filter by Selection

A quick way to filter a table is with the Filter by Selection feature. This allows you to streamline the results and make sure you are seeing the exact information that you’re searching for.

  1. Click a cell with a value you want to filter by.
  2. Click the Selection button on the ribbon.

    The menu that appears contains four filter-related commands, described in the table below.

  3. Select an option from the menu.
    Filter by Selection

Access applies the filter.

You can also apply a selection filter by right-clicking the field value you want to filter by and selecting one of the options at the end of the contextual menu.

Filter by Selection Menu Commands
Equals [selected field value] Displays only records with the selected value. Example: If John is selected, only records with John in this column are displayed.
Does Not Equal [selected field value] Displays all records that don't contain the selected value. Example: If John is selected, records with John in this column are not displayed, but Johnson is.
Contains [selected field value] Displays all records that contain the selected value in any form. Example: If John is selected, John and Johnson are displayed.
Does Not Contain [selected field value] Displays records that don’t contain the selected value in any form. Example: If John is selected, neither John nor Johnson is displayed.

FREE Quick Reference

Click to Download