Access™ 2007 Bible

Chapter 5. Using Operators and Expressions in Access

IN THIS CHAPTER

• Understanding operators, functions, and expressions and how they're used

• Reviewing types of operators

• Looking at types of functions

• Creating an expression

• Examining special identifier operators and expressions

• Creating and using text expressions as criteria

• Using the Like and Not operators and wildcards

• Creating and using date and numeric expressions as criteria

• Using the And/Or operators in single-field criteria

• Using the In and Between...And operators

• Searching for Null data

• Using the And/Or operators across several fields

• Using functions as expressions for criteria

• Creating and using a calculated field

In 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 expressions to calculate information, compare values, and display data in a different format — using queries to build examples.

You aren't limited to using operators and expressions inside of queries. You'll also learn how to use them when creating calculated fields on forms and reports, and when programming in Visual Basic for Applications (VBA). This chapter only uses queries to demonstrate the use of operators and functions.

Note

This chapter will use the Chapter05Start.accdb database. If you haven't already copied it onto your machine from the CD, you'll need to do so now.

Note

For more on using operators and expressions ...