Microsoft Access 2010 Bible

171

CHAPTER

Using Operators and

Expressions in Access

IN THIS CHAPTER

Understanding operators in

expressions

Creating complex queries

Building queries with simple

criteria

Using multiple criteria in a

query

Composing complex query

criteria

I

n previous chapters, you created queries using selected fields from one
or more tables. You also sorted the data and set criteria to limit the
results of a query. This chapter focuses on using operators and expres-
sions to calculate information, compare values, and display data in a differ-
ent format — using queries to build examples.

This chapter uses queries to demonstrate the use of operators and functions,
but the principles in this chapter’s exercises apply anywhere operators and
expressions appear in Access.

On the CD-ROM

This chapter uses the Chapter05.accdb database. If you haven’t already
copied it onto your machine from the CD, you’ll need to do so now.

Cross-Reference
For more on using operators and expressions in forms, reports, and VBA, see
Chapters 7, 8, 9, and 13. Using the VBA programming language is discussed in
Chapters 10 and 11.

Introducing Operators

Operators let you add numbers, compare values, put text strings together,
format data, and perform a wide variety of tasks. You use operators to
instruct Access to perform a specific action against one or more operands.
The combination of operators and operands is known as an expression.