Chapter 2. Building Criteria Expressions

The heart of any query is its criteria. This is a set of expressions that determine the records that appear in the dynaset. In this chapter, you go beyond the simple criteria that you learned about in Chapter 1, “Creating a Basic Query,” and examine more complex examples that enable you to unleash the full power of Access queries.

The queries you've seen so far are simple filters that use literal values to select matching table records. To create more advanced queries, however, you have to go beyond literals and construct ...

Get Microsoft® Access 2003 Forms, Reports and Queries 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.