Business Solutions Microsoft® Office Access 2007 Forms, Reports, and Queries

11. Building Criteria Expressions

IN THIS CHAPTER

Using Operands in Criteria Expressions

Using Operators in Criteria Expressions

Setting Up a Calculated Column

Using the Built-In Functions

Working with the Expression Builder

From Here

The heart of any query is its criteria. They are 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 and Using a Form,” 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 ...