Microsoft® Office Access™ 2007 Plain & Simple

Filtering Table Records

Often you will be interested in viewing only some of the records in a table. For example, you might want to find all of your customers or suppliers from a particular state or country. You can narrow the records shown in a table by creating a filter, which hides records not meeting your criteria. The records aren’t erased, though; when you remove the filter, they display normally.

Filter Table Records

1. Open a table in Datasheet view.

2. Select the text to serve as the base for the filter.

3. Click the Home tab.

4. Click Selection.

5. Click ...