4.2 Enhance Your Results

After you have executed your query you can sort, group and summarize the data using the commands in the Options menu.

This facility gives you the flexibility of varying the data's presentation once you have seen the results - without having to change the query or to rerun it.

When you specify totals for the query, an additional row for each total will appear at the end of each group as well as a grand total at the end of the results.

Each summary row is identified by a label instead of a row number.

If the:

If the data in a column cannot be summarized (for example, if the column is alphanumeric) the total for that column will be blank.

For details about the Sort Options, Group By and Summary Options commands, refer to Creating and Running Queries.

Further Information

4.2.1 Use Edit Codes to Format your Output