- Click in the cell that displays Expression.
Two buttons appear on the right. The arrow button displays a list of fields you can use in the filter expression. The ellipsis (...) button launches Expression Builder, which you can use to create a more complex expression.
- For Expression, specify the filter expression.
- For Operator, select an operator from the drop-down list.
- For Value 1, specify the value to search. You can type the value, select from a list of values, or use Expression Builder to create a more complex value expression.
If you selected the Is True, Is False, Is Null, or Is Not Null operator, you do not specify a value.
- For Value 2, specify a value only if you selected the Between or Not Between operator.