1. Home
  2. Microsoft Products
  3. Microsoft Office Access 2003 in 24 hours

Applying Advanced Filters

Using advanced filters, you can further refine the data that appears in a query result. Here are the steps involved:

  1. Open (in Datasheet view) the query or table whose data you want to filter.

  2. Select Records | Filter | Advanced Filter/Sort. The filter design grid appears.

  3. Add to the design grid the fields on which you want to filter.

  4. For each field on the grid, enter the value or expression that you want to use as a filter in the Criteria cell for the fields you have included.

  5. Click Apply Filter or select Filter | Apply Filter/Sort. Access applies the filter that you created.


    		Part I: Introduction to Relational Databases and Access 2003
    		Part II: Working with Existing Databases and Objects
    		Part III: Creating Your Own Database and Objects
    		Part IV: Power Access Techniques
    		Hour 14. Power Table Techniques
    		Hour 15. Power Query Techniques
    		Adding Calculated Fields to Select Queries
    		Applying Advanced Filters
    		Creating and Running Parameter Queries
    		Creating and Running Action Queries
    		Using Aggregate Functions to Summarize Numeric Data
    		Working with Outer Joins
    		Refining Queries with Field, Field List, and Query Properties
    		Summary
    		Q&A
    		Workshop
    		Hour 16. Power Form Techniques
    		Hour 17. Power Report Techniques
    		Part V: Advanced Topics