Microsoft Access 2010 Bible

Chapter 5: Using Operators and Expressions in Access

213

FIGURE 5.20

Using multiple Ands and Ors across fields. This is a rather complex Select query.

Summary

In this chapter, you learned how to use various operators to create expressions in Access. You used

mathematical operations to perform arithmetic calculations, relational operators to compare values,

string operators to concatenate and match text patterns using wildcards, and Boolean operators to

perform logical operations. You also used Is, Not, and Between...And operators.

You implemented these operators in queries to see them in action. You created simple and com-

plex criteria by creating expressions using the various types of operators. You learned the differ-

ence between using And and Or in your queries and how to set the QBE pane to get the desired

results.