Article ID: 918808
Article Last Modified on 10/15/2007
APPLIES TO
- Microsoft Office Access 2007
SYMPTOMS
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.
CAUSE
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.
RESOLUTION
To group a report on a column that contains a lookup field, follow these steps:
- Start Access 2007.
- Click Microsoft Office Button, and then click Open.
- Select the name of the .mdb file that you want to open, and then click Open.
- Select the report that you want to open.
- On the Formatting tab, click Grouping in the Grouping and Totals group under Report Tools.
- In the Group, Sort, and Total pane, click Add a group.
- Select the column that contains the lookup field.
STATUS
This behavior is by design.
Additional query words: AC2007 ACC2007 Access2007
Keywords: kbtshoot kbprb kbexpertiseinter KB918808