O'Reilly logo

2007 Microsoft® Office System Step by Step, Second Edition by Joan Lambert, John Pierce, Steve Lambert, M. Dow Lambert III, Curtis D. Frye, Joyce Cox

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required