Using Operators and Expressions in Access
Michael Alexander, Dick Kusleika · 2018
This chapter uses queries to demonstrate the use of operators and functions, but the principles in the chapter's exercises apply anywhere operators and expressions appear in Access. The operators can be grouped into the following types: mathematical, comparison, string, Boolean (logical), and miscellaneous. One of the most common uses of operators and expressions is when building complex query criteria. The chapter deals specifically with building query criteria using operators and expressions. Knowing how to specify criteria is critical to designing and writing effective queries. Although queries can be used against a single table for a single criterion, many queries extract information from several tables using more complex criteria. In select queries, operators are used in either the Field cell or the Criteria cell of the Query by Design (QBD) grid.