March 2008
Beginner
960 pages
24h 34m
English
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. ...
Read now
Unlock full access