In Access XP filtering records may seem confusing at first. This free lesson offers step-by-step instructions.
There are times when you might want to view only 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.