GCFLearnFree.org

As a website designer, I can say you have one of the best learning websites.”

Online Learner

GCFGlobal.org
Creating Opportunities For A Better Life.®
  • All Topics
  • Access 2003
  • Filtering Records

Access 2003

Single page view print copy

Filtering Records

Performing a Filter By Selection

At times, you might want to view only those records that match a specific criterion. A filter is a technique that lets you view and work with a subset of data. Applying a filter to an Access table, form, or query temporarily hides records that don't meet your search criteria. For example, you may only want to work with data pertaining to a specific zip code.

To Filter By Selection:

  • Click anywhere in the field where you want to filter the records in a table.

    Select Field to be Used in Filter
  • Click the Filter by Selection button in the Standard toolbar, or choose RecordsFilterFilter By Selection from the menu bar to apply the filtering.

    Filter by Selection Option in the Records Menu
  • The filter produces a display that shows only those records that match the filter's definition (e.g., North Carolina). The status area reflects only the filtered records.

    Resulting Display of Filtered Records
previous next
previous 1 2 3 4 5 6 7 next
Terms Of Use

©1998-2014 Goodwill Community Foundation, Inc. All rights reserved.