User`s guide

5 Using Visual Query Builder
5-42
Removing Grouping of Statements
To use the WHERE Clauses dialog box to remove grouping criteria from the previous
example:
1
In Current clauses, select (January > 1000 AND.
2
Press Shift+click to select February > 1000 AND and March > 1000) also.
3
Click Ungroup.
The parentheses are removed from the statements, indicating that their grouping is
removed.
Displaying Results in a Specified Order
Use Order by in Advanced query options to specify the order in which query results
display.
This example uses the basic_where.qry query you created in “Retrieving Data That
Meets Specified Criteria” on page 5-35. The results of basic_where.qry are sorted
so that January is the primary sort field, February the secondary, and March the last.
Results for January and February appear in ascending order, and results for March
appear in descending order.
To specify the order in which results appear in basic_where.qry:
1
Load basic_where.qry.
2
Set the Data return format preference to cellarray.
3
Set Read NULL numbers to NaN.