About expressions
An expression is a calculation that uses a combination of operators, functions, field names, and constants.
You can use an expression as criteria to select records. To use an expression in the Criteria pane, you select the field in the Criteria Field that contains the values you want to evaluate, and then you enter an operator and value in the Value box. When you select a criteria field, make sure that you select it from the correct table.
Expressions that use arithmetic operators To retrieve records based on the result of a calculation, create an expression that uses the arithmetic operators for addition, subtraction, multiplication, or division. See examples of expressions that use arithmetic operators.
Expressions that use comparison operators Comparison operators compare one value against another. For example, to find all orders where the number of units sold is greater than 1,000, type >1000 as the criteria for the Quantity field. See examples of expressions that use comparison operators.
Expressions that use logical operators Logical operators compare values, similar to comparison operators. For example, to retrieve all records for sales outside of France, use the phrase Not France as the criteria for the Country field. See examples of expressions that use logical operators.
Expressions that use other types of operators You can use additional operators to find values that are equal to any of several values, determine whether a record does or does not contain a value in a specified field, or find records by using a wildcard character. See examples of expressions that use other types of operators.