Microsoft KB Archive/918808

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

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 &quot;Resolution&quot; section.



RESOLUTION
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.



STATUS
This behavior is by design.

Additional query words: AC2007 ACC2007 Access2007

Keywords: kbtshoot kbprb kbexpertiseinter KB918808

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.