Examples of expressions that use other types of operators
From Microsoft Query
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%' |