Insert an additional sorting or grouping field or expression in a report
a) Open the report in Design view.
b) Click Sorting And Grouping (View menu) on the toolbar to display the Sorting And Grouping box.
c) In the Sorting And Grouping box, click the selector of the row where you want to insert the new field or expression, and then press INSERT.
d) In the Field/Expression column of the blank row, select the field you want to sort on, or type an expression. When you fill in the Field/Expression column, Microsoft Access sets the Sort Order to Ascending. To change the sort order, select Descending from the Sort Order list.
|