O'Reilly logo

Special Edition Using Microsoft® Office XP by Woody Leonhard, Ed Bott

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

Creating and Applying Filters

When you use criteria in a query, Access displays a subset of records in the underlying data source. To revise the selection criteria, you have to open the query in Design view and enter one or more new expressions in the Criteria row of the design grid. You then have the option of saving these new criteria as part of the permanent design of your query.

A filter is a faster, more convenient way to temporarily focus on specific records in a query, table, or form. You can develop and apply filters quickly, without switching to Design view, and return to the unfiltered display whenever you want to see the entire set of records again.

The easiest way to create a filter is to base it on the contents of an existing record. ...

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