Use the Specify WHERE Criterion window to create WHERE clauses for a view based on the selected columns. You can build WHERE clauses for simple views or for views on tables that contain more than one record type. If you are proficient with SQL, you can also modify the view SQL in the property pages after this wizard creates the view.
If you select a column that contains 88 values, the operator changes to = and, in the Value field, you can select the record type that you want to filter on.
88 MYVALUES VALUE "A","X" THRU "Z","B"
The two WHERE criteria are:
Column | Operator | Value | AND/OR |
---|---|---|---|
MYVALUES | BETWEEN | 'X' AND 'Z' | OR |
MYVALUES | IN | ('A','B') |
Individual values will use an IN clause and the range values will be a BETWEEN and an OR
When you select IS NULL or IS NOT NULL as the operator, you cannot select a value in the Value field.
When you select BETWEEN or NOT BETWEEN as the operator, you can specify the minimum and maximum values for the range.
When you select IN or NOT IN as the operator, you can provide a list of values.