Show All

Sort records in a query

1. Make sure the Auto Query button is pressed in.
2. In the result set, click in the field you want to sort.
3. To sort records in an ascending sort order, click Sort Ascending .

   To sort records in a descending sort order, click Sort Descending .

Notes

• To sort multiple columns at one time, arrange the columns from left to right in the Data pane in the order you want to sort them. Press SHIFT and click the column headings to select the columns you want to include in the sort, and then click Sort Ascending or Sort Descending.
• To return the records to their original order, click Sort on the Records menu. In the Sorts in Query box, click the field for which you want to remove the sort order, and then click Remove.
• If you change the order of columns in the result set after you sort the records, the sort order is not affected.