Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 303192 - Last Review: January 31, 2007 - Revision: 4.1
ACC97: Running Sum Produces Incorrect Results
This article was previously published under Q303192
Novice: Requires knowledge of the user interface on single-user
computers.
On This Page
SYMPTOMS
When you create a report that has the Detail section's
Visible property set to
No, and the Detail section contains a text box that displays a
running sum, the first record at the top of each page may display incorrect
results.
CAUSE
This behavior can occur if a text box in a group footer
references the value of the running sum and the
Keep Together property for that grouping is set to
No.
RESOLUTION
To resolve this behavior, set the
Keep Together property for the grouping to
Whole Group:
- Click the OrderID field, and then on the Report Design toolbar, click Sorting and Grouping.
- In the Field/Expression box, click OrderID, and then in the Group Footer box, click Yes.
- In the Keep Together box, click Whole Group, and then quit the Sorting and Grouping dialog
box.
MORE INFORMATION
Steps to Reproduce the Behavior
- Open the Northwind sample database, and then create a
tabular AutoReport that is based on the Order Details table:
- In the Database window, click the Reports tab, and then click New.
- In the New Report dialog box, click AutoReport: Tabular, click the Order Details table in the box at the bottom of the dialog box, and then click OK.
- After the report is created, on the View menu, click Design View.
- In the Detail section, add a text box.
- Right-click the new text box, click Properties, and then click the Data tab.
- In the Control Source box, click UnitPrice, and then in the Running Sum box, click OverGroup.
- Click the Other tab, type RunSum in the Name box, and then close the Properties dialog box.
- Click the OrderID field, and then on the Report Design toolbar, click Sorting and Grouping.
- Click OrderID in the Field/Expression box, click Yes in the Group Footer box, and then quit the Sorting and Grouping
dialog box.
- Click the Report Footer section, and then create two text boxes.
- Right-click the first text box, and then click Properties.
- Click the Data tab, type =[RunSum] in the Control Source box, and then quit the Properties dialog box.
- Right-click the second text box, and then click Properties.
- Click the Data tab, type =[UnitPrice] in the Control Source box, and then quit the Properties dialog box.
- Right-click the Detail section, and then click Properties.
- Click the Format tab, click No under Visible, and then close the Properties dialog box.
- Preview the report, and note that the first record on each
page (except the first) produces an erroneous value in the text box that
references the RunSum text box.
APPLIES TO
- Microsoft Access 97 Standard Edition
Retired KB Content DisclaimerThis article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.
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
Be the first to leave feedback, to help others about this knowledge base
article.
(Optional) Name
(Optional)
Public URL Or Email
Comments
No
HTML -- Text Only Please