Summing over multiple groups

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ivan Debono - 30 Oct 2005 09:14 GMT

Hi all,

I have a report with 3 groups: group1, group2, and group3. I have a number
field placed on the detail section.

I want to sum up the number field and place the running total on each of the
groups, so that group1 will display the total of the detail section, group2
will display the total of group1, and group3 will display the total of
group2.

How can I do it?

Thanks,
Ivan

Reply to this Message

Marshall Barton - 30 Oct 2005 17:15 GMT

>I have a report with 3 groups: group1, group2, and group3. I have a number
>field placed on the detail section.
[quoted text clipped - 3 lines]
>will display the total of group1, and group3 will display the total of
>group2.

Not totally clear what you want here, but maybe this will do
it?

Add a text box to the group footer section. Set its control
source expression to =Sum(thenumberfield)
and set its RunningSum property to Over All

Signature

Marsh
MVP [MS Access]

Reply to this Message