Change sorting and grouping levels

1. In the Sorting And Grouping box, click the row selector of the field or expression you want to move.
2. Click the selector again, and drag the row to a new location in the list.

Note  If the groups you're rearranging have headers or footers, Microsoft Access moves the headers, footers, and all the controls in them to their new positions. However, you must adjust the locations of the controls in the headers and footers yourself.

1. In the Sorting And Grouping box, click the row selector of the row above which you want to insert the new field or expression, and then press INSERT.
2. 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.

1. In the Sorting And Grouping box, click the row selector of the field or expression you want to delete, and then press DELETE.
2. Click Yes to delete the sorting or grouping level, or click No to keep it.

Note  If the field or expression you delete has a header or footer, Microsoft Access deletes the header or footer and its controls.

1. Click Properties on the toolbar to display the report's property sheet.
2. Click the OrderBy property box, and then specify the field and sort order you want to sort on.
   • To sort records in one field in ascending order, type the field name enclosed in brackets ([ ]) followed by ASC.

     [fieldname1] ASC

   • To sort records in one field in descending order, type the field name enclosed in brackets ([ ]) followed by DESC.

     [fieldname1] DESC

   • To sort records in more than one field in ascending or descending order, type the setting this way:

     [fieldname1] ASC,[fieldname2] DESC

Note  If you don't specify ASC or DESC after field names, Microsoft Access sorts in ascending order, the first listed field first, then the next listed field, and so on.

1. Click the control you want to move to a higher group level.
2. Do one of the following:
   • To group on one field from a table or query, click Promote on the toolbar.
   • To group on all fields in a table or query, click Group by Table on the toolbar.

Microsoft Access adds a group header that contains an expand control and a record navigation section that contains a record navigation control. If you grouped on one field, Access moves the control on which you grouped to the group header. If you grouped on a table or query, Access moves all the controls— including controls bound to fields that are in that table or query and controls bound to Lookup fields— to the group header.

1. Click the section bar of the group header that you want to move to a lower group level.
2. Click Demote on the toolbar.

Microsoft Access moves the controls in the selected group header and footer into the header and footer of the next lower group level.

Note  To change a field that is used to group records, follow the steps to remove the group level, and then follow the steps to add a group level with the field you want.