/text/shared/02/12100100.xhp sorting; databases databases; sorting

Sort Order Specifies the sort criteria for the data display.

While the functions Sort in Ascending Order and Sort in Descending Order sort by one criterion only, you can combine several criteria in the Sort Order dialog. You can remove a sorting that has been performed with the Reset Filter/Sorting icon. Sorting Use this area to enter sorting criteria. If you enter additional sorting criteria under and then, the data matching the content of the higher-order criterion is ordered according to the next criterion. If you sort the field name "First name" in ascending order and the field name "Last name" in descending order, all records will be sorted in ascending order by first name, and then within the first names, in descending order by last name. Field name Specifies the data field name whose content will determine the sort order. Order Specifies the sort order (either ascending or descending). and then Specifies additional subordinate sort criteria from the other fields.