The "Group On" option does not appear in the shortcut menu for lookup fields when you create a report in an .mdb file in Access 2007

Consider the following scenario. You open an .mdb file in Microsoft Office Access 2007. Then, you open a report for a table that contains a lookup field. In this scenario, when you right-click a column that contains a lookup field, the Group On option does not appear in the shortcut menu.

This behavior occurs because Access 2007 uses a group level and a sort level for the .accdb files. For an .mdb file, Access 2007 cannot automatically create these levels for a shortcut menu. Instead, you must manually specify the lookup field by using the method that is described in the "Resolution" section.

To group a report on a column that contains a lookup field, follow these steps:

1. Start Access 2007.
2. Click Microsoft Office Button, and then click Open.
3. Select the name of the .mdb file that you want to open, and then click Open.
4. Select the report that you want to open.
5. On the Formatting tab, click Grouping in the Grouping and Totals group under Report Tools.
6. In the Group, Sort, and Total pane, click Add a group.
7. Select the column that contains the lookup field.

This behavior is by design.