Microsoft® Office System Step by Step -- 2003 Edition

Filtering Information in a Table

Sorting the information in a table organizes it in a logical manner, but you still have the entire table to deal with. If your goal is to locate all records containing information in one or more fields that match a particular pattern, one of the available Filter commands will satisfy your needs. For example, you could quickly create a filter to locate every customer of The Garden Company who lives in Seattle, or everyone who placed an order on January 13, or all customers who live outside of the United States.

You can apply simple filters while viewing information in a table or a form. These filters are applied to the contents of a selected field, but you can apply another filter to the results of the first one ...