Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 918808 - Last Review: October 15, 2007 - Revision: 1.4
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:
- 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.
This behavior is by design.
APPLIES TO
- Microsoft Office Access 2007
| kbtshoot kbprb kbexpertiseinter KB918808 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate