• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 35. Entering, Finding, and Filte... > Creating and Applying Filters

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.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint