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 table for records that meet multiple criteria, or with criteria based on complex expressions, 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 in two states. ...
Get 2007 Microsoft® Office System Step by Step, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
