2007 Microsoft® Office System Step by Step

Locating Information That Matches Multiple Criteria

The filtering methods discussed earlier in this chapter are quick and easy ways to narrow down the amount of information displayed, as long as your filter criteria are fairly simple. But suppose you need to locate something more complex, such as all the orders shipped to Midwest states between specific dates by either of two shippers. When you need to search a single table for records that meet multiple criteria, or with criteria based on complex expressions as criteria, you can use the Advanced Filter/Sort command, available from the Advanced Filter Options list.

You work with the Advanced Filter/Sort command in the design grid.

In this exercise, you will filter a table to display customers located ...