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 ...

Get Microsoft® Office Access™ 2007 Plain & Simple now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.