In the Ad Hoc Editor, you can sort the rows of a table by any field, using a number of different methods.
To sort a table, complete the following steps:
Click the Sorting icon .The Sort window appears. If the table is already sorted, the window shows the fields that are used.
To add a field to sort on, double-click the field in the Available Fields panel. The Available Fields panel now lists only fields that are not already in the Sort On panel.
Select one or more fields to sort by. You can also use Ctrl-Click to select multiple fields.
Click the Move to Right button to add the selected field to the Sort On panel.
To arrange the sorting precedence of the fields, select each field in the Sort window and click one of the following buttons:
Move to Top
Move to Bottom
Move Up
Move Down
To remove a field from the Sort On panel, select it and click the Move to Left button .
Click the OK button. The table updates to display the rows sorted by the selected fields. You can also sort a table using the following methods:
In the Fields section of the Domain Selection panel, right-click a field and select Use for Sorting from the context menu. In this case, the table is sorted by a field that isn't in the table; you may want to note the sorting fields in the title.
On the canvas of the Ad Hoc View panel, right-click a column header and select Use for Sorting from the context menu.