Change the group levels on a data access page

1. Open the data access page in Design view.
2. Do one or more of the following:

   Add a group level

   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.

   Remove a group level

   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.