In forms where the records are listed in a grid, you can sort data in ascending order (a-z) or descending order (z-a).
Sort by one field
You can sort data by using a single criterion. For example, you can sort the items in the Items table according to the Item type instead of the Item number which is the default sorting.
Select any field in the column that you want to sort by.
On the Editmenu, point to Sort, and then select either Sort ascendingor Sort descending.
You can sort data by clicking the column header in the table. Click the header again to reverse the sort order.
You can also sort data by right-clicking a field that you want to sort by, and then select either Sort ascendingor Sort descendingfrom the context menu.
Sort by more than one field
You can use Advanced sorting if you want to sort by more than one field. For example, if you want to sort the customers in the table first by and then by .
On the Editmenu, point to Filter, and then click Advanced Filter/Sort.
Click the tab.
Press CTRL+N to add a new line.
Under , select the table that contains the field to sort.
Under , select your sorting field.
In Searchdirection, select or .
Repeat step 3 through 7 to add more sorting criteria.
Click the or buttons to change the sort order.