Microsoft Office Access 2003 in a Snap

Chapter 13. Power Query Techniques

IN THIS CHAPTER:

• 74 Apply Advanced Filters

• 75 Create and Run Parameter Queries

• 76 Create and Run Action Queries

• 77 Incorporate Aggregate Functions

• 78 Refine Your Queries with Field, Field List, and Query Properties

Apply Advanced Filters

Before You Begin
✓	48	Create Queries
✓	52	About Building Queries Based on Multiple Tables
✓	53	Create Calculated Fields

See Also
→	75	Create and Run Parameter Queries
→	77	Incorporate Aggregate Functions

Using advanced filters, you can further refine the data that appears in a query result. You can apply advanced filters to tables or queries while in Datasheet view.

1. Open a Query or Table

   In Datasheet view, open the query or table whose data you want to filter.

2. Select Records, Filter, Advanced Filter/Sort ...