User`s guide

5 Using Visual Query Builder
5-46
1
From the Fields list box, select the entry whose value to restrict.
2
Define the Condition for the selected field, as described in “Retrieving Data That
Meets Specified Criteria” on page 5-35.
3
Select Operator to add another condition.
4
Click Apply to create the clause.
The subquery appears in the Current clauses area.
5
Repeat steps 1 through 4 to add more conditions as needed.
6
Change the clauses as needed:
• To edit a clause:
a
Select the clause from Current clauses and click Edit.
b
Modify the Fields, Condition, and Operator fields as needed.
c
Click Apply.
• To group clauses:
a
Select the clauses to group from Current clauses. Press Ctrl+click or
Shift+click to select multiple clauses.
b
Click Group. Parentheses are added around the set of clauses.
To ungroup clauses, select the clauses and then click Ungroup.