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%' |