Access XP

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