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. ...
Get Special Edition Using Microsoft® Office XP 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.
