Examples of expressions that use other types of operators

The following table lists operators you can use to select a range of values, 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.



Operator


Meaning


Example
In the
Criteria Field, click

In the
Value box, type
Between Shows a range of values between and including the two endpoints Finds records for order amounts between $1,000 and $3,000 Order_Amt Between 1000 And 3000
In Determines whether a value is equal to any of several values in a list Finds records for customers in Portland, Seattle, and Denver City In('Portland',
'Seattle',
'Denver')
Is Null Determines whether a record has no value in the specified field Finds employee records that don't have an entry for the employee's supervisor Reports_To Is Null
Is Not Null Determines whether a record has a value in the specified field Finds employee records that have an entry for the employee's supervisor Reports_To Is Not Null
Like Uses Like and the wildcard character % to compare values Finds records for employees whose last names begin with the letters "Sm", such as Smith and Small Last_Name Like 'Sm%'