/en/access2000/finding-records/content/
Sometiomes 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.
You can apply filters to filtered data to narrow your search even further.
If you want to see all data in a form or table except for a certain criterion, use Filter Excluding Selection.
Remove this filter by clicking the Remove/Apply Filter button.
All sorting and filtering commands are available in the Records menu (on the menu bar) and on the shortcut menu.
The Filter by Form feature works the same way as the Filter by Selection method, except you set up your search values on a blank form or datasheet.
/en/access2000/queries/content/
About cookies on this site
Sharing your cookies helps us improve the site, optimize your experience, and understand the extent of our impact. By closing this banner, you agree to the use of cookies on this website (This option applies to users outside the United States and Europe). Learn more about how we use cookies by clicking on Cookie Settings.