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.

Back to the top

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.

Back to the top

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.

Back to the top

This behavior is by design.

Back to the top