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.

1. Select any field in the column that you want to sort by.

2. On the Editmenu, point to Sort, and then select either Sort ascendingor Sort descending.

Tip
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.

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 Customerstable first by Customer groupand then by Name.

1. On the Editmenu, point to Filter, and then click Advanced Filter/Sort.

2. Click the Sortingtab.

3. Press CTRL+N to add a new line.

4. Under Table, select the table that contains the field to sort.

5. Under Field, select your sorting field.

6. In Searchdirection, select Ascendingor Descending.

7. Repeat step 3 through 7 to add more sorting criteria.

   Note
   Click the Upor Downbuttons to change the sort order.