Access XP


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 that you want to filter the records in the table.
- Click the Filter by Selection button in the standard toolbar or choose Records
Filter
Filter By Selection from the menu bar to apply the filtering.
- 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.