Sorting records

In a typical customer list report, customer names are listed alphabetically. In this example, you will sort the customer names alphabetically within each region.

To sort records

1. While on the Preview tab, click Sort Order on the Standard toolbar.

   The Record Sort Order dialog box appears.

   

   The Report Fields list box displays all fields currently on your report. You can choose to sort based on any of these fields.

   The Sort Fields list box displays the fields that are already sorted in the report. Since the region field has already been sorted, the sorting you are about to do will be within each region, and not for the entire report.

2. Highlight the Customer Name field and click Add. Notice that the Customer Name field now appears in the Sort Fields list box.
3. Select Ascending for the Sort Direction and click OK.

   The report should now look similar to the following:

   

Notice that the records within each group are in alphabetic order.