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.
- Click a cell with a value you want to filter by.
- Click the Selection button on the ribbon.
The menu that appears contains four filter-related commands, described in the table below.
- Select an option from the menu.
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 DownloadFree to distribute with our compliments; we hope you will consider our paid training.
