Filtering Records

In Access filter data so you see only what you want to see. This will help you filter out the information in your Access database that you don't need.

Filtering by selection

When you Filter by Selection, Access 2007 returns the results to you as a subset of records in the table. It assumes that your current selection is what you want to use as your filter value, or criteria.

To use the Filter by Selection feature:

Filter by SelectionFiltering by Selection of Raleigh

Sorting or filtering the filtered results

Access 2007 lets you narrow the filtered results further by applying another level of sorting or filtering. To do this:

Another way to do this is to use the Advanced Filter command.