Sorting

To sort, proceed as follows:

1. Select the field you want to sort according to in the upper right-hand window.

2. Drag this field to the Sorting Fields toolbox.

If multiple fields have been dropped into the toolbox, their order determines in which order sorting will take place. The system sorts according to the first field, then according to the second, and so on.

If you want to change the order in which fields are sorted, you can do so by selecting and moving fields within the toolbox.

An icon appears after each field indicating the direction in which the field is sorted (ascending/descending). Simply clicking on this icon reverses the sort direction.

Sorting can be undone by selecting the field in the toolbox and dragging it to the trash.

Whenever a field is identified as a sort field, a control level text is displayed the field in the Query Painter. Subtotals are displayed for numeric fields at the end of each control level. If a counter has been attached to the field, a partial counter value (subtotal) is recorded at the end of each control level. For more information, see Totaling and Counting Fields and in the section on Control Level Texts.