User`s guide

Fine-Tuning Queries Using Advanced Query Options
5-39
To modify basic_where.qry:
1
Click Where in VQB. The WHERE Clauses dialog box appears.
2
Modify the query to retrieve data if sales in January, February, or March exceed
1500 units.
a
In Current clauses, select StockNumber < 500000 and click Edit.
b
For Operator, select OR and click Apply.
c
In Fields, select January. For Relation, select > and enter 1500 in its field.
For Operator, select OR. Click Apply.
d
Repeat step c twice, specifying February and March in Fields.
The WHERE Clauses dialog box now looks as follows.