- Click the cell below Expression. Two buttons appear on the right. The arrow button displays a list of fields you can use in Expression. The ellipsis (...) button launches Expression Builder, which you can use to create a more complex expression.
- For Expression, select a field. You can also type the filter expression.
- For Operator, select an operator from the drop-down list.
- For Value 1, specify the search value. You can type the value, select from the list of values, or use Expression Builder to create a more complex value expression. If you select 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 select the Between or Not Between operator. Figure 11-3 shows some examples of filter conditions.
Figure 11-3 Filter conditions in Edit Data Set