O'Reilly logo

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

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

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

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