O'Reilly logo

Microsoft Office Access 2003 in a Snap by Alison Balter

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

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 ...

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