Running sum problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mary - 09 Mar 2007 19:16 GMT

Please help - I'm doing something wrong but can't seem to get it!

Report totals expenses for projects. Projects can have several expenses and
the budget is listed each time. I only need the budget listed once. Created
text box with Running sum for Budget named txtBudget, running sum over group.
(also tried over all)

Report totals by Director.

Over group doesn't work. Over all works for first director, second director
is off, figure includes both first and second directors. But over group
doesn't total right. Do I have it in the wrong section, or set wrong? Can
someone help? Report has groupings on Project & Director.

Thanks!
Mary

Reply to this Message

Marshall Barton - 09 Mar 2007 23:19 GMT

>Please help - I'm doing something wrong but can't seem to get it!
>
[quoted text clipped - 9 lines]
>doesn't total right. Do I have it in the wrong section, or set wrong? Can
>someone help? Report has groupings on Project & Director.

You need to add a grouping level for the project field. The
budget amount would just be a bound text box in this group's
header or footer section. (The budget amount text box
should not be in the detail section.)

Then add another text box (named txtRunBudget) to the same
group header/footer. Bind it to the same field and set this
one's RunningSum to Over Group.

The next higher group (presumably the director group) can
the display the total in its group footer by using a text
box with the expression:
=txtRunBudget

Signature

Marsh
MVP [MS Access]

Reply to this Message

Mary - 12 Mar 2007 14:28 GMT

Still not working...I also have the report sorted by the AD field and that
seems to be the problem. The total in the Director field is displaying the
total for the last AD in that group instead of the sum of all the AD's in the
group.

Currently I have group footers for Project and Director. Nothing in the
Detail section, project details are displayed in the Project footer.
BudgetAmount is a bound control in this section. I added the additional text
box named txtRunBudget with Running Sum set to Over Group. Added text box in
Director footer =txtRunBudget. I've tried putting the text boxes in the AD
footer, but totals are still off.

> >Please help - I'm doing something wrong but can't seem to get it!
> >
[quoted text clipped - 23 lines]
> box with the expression:
> =txtRunBudget

Reply to this Message

Mary - 12 Mar 2007 14:45 GMT

Finally got it, thanks! Added text fiedl in AD footer with expression
=txtrunbudget, set it's running sum to over group, then referred to that text
box in the Director footer.

> >Please help - I'm doing something wrong but can't seem to get it!
> >
[quoted text clipped - 23 lines]
> box with the expression:
> =txtRunBudget

Reply to this Message