Share this Page URL

Chapter 3. Managing the Consistency, For... > Expressions and the Expression Build... - Pg. 98

Managing the Consistency, Format, and Integrity of Your Data Table 3-4. Operators for Use in Expressions Operator Mathematical operators + - * / Comparison operators = > < Like Logical operators Or And Not Between Meets any one condition Meets all conditions Negates a condition Falls between two values and includes the values Equals Greater than Less than Greater than or equal to Less than or equal to Not equal to String matches a pattern Addition Subtraction Multiplication Division Description 98 As with many other operations in Access, you can use a tool to help create an expression. For expressions, the tool is named the Expression Builder; it's shown in Figure 3-2.