Running Sums for Groups

[ehale]

Hello. I have a report that groups on Claim #. I have a
Group Footer in which I would like the sum of the Losses
Paid per group to display at the end of each group. If I
add a text box bound to Losses Paid field to the group
footer and set Running Sum property to Over Group, I only
get the value of the last Losses Paid in the group, not
the sum of all of them. Any ideas on why this might be?
Or ideas on a better way to get totals per group? I
appreciate any help. thanks!

 

[Marshall Barton]

Hello. I have a report that groups on Claim #. I have a
Group Footer in which I would like the sum of the Losses
Paid per group to display at the end of each group. If I
add a text box bound to Losses Paid field to the group
footer and set Running Sum property to Over Group, I only
get the value of the last Losses Paid in the group, not
the sum of all of them. Any ideas on why this might be?
Or ideas on a better way to get totals per group?

The RunningSum text box would have to be in the detail
section with the group footer text box referring to the
detail section text box. But there might be an easier way
to calculate the total.

Instead of using RunningSum, I think you can get what you
want just by using the expression =Sum([Losses Paid]) in
your group footer text box.

 

[erica]

Marshall! You're my favorite person right now It
worked and I appreciate your help so much.

-----Original Message-----

Hello. I have a report that groups on Claim #. I have a
Group Footer in which I would like the sum of the Losses
Paid per group to display at the end of each group. If I
add a text box bound to Losses Paid field to the group
footer and set Running Sum property to Over Group, I only
get the value of the last Losses Paid in the group, not
the sum of all of them. Any ideas on why this might be?
Or ideas on a better way to get totals per group?

The RunningSum text box would have to be in the detail
section with the group footer text box referring to the
detail section text box. But there might be an easier way
to calculate the total.

Instead of using RunningSum, I think you can get what you
want just by using the expression =Sum([Losses Paid]) in
your group footer text box.

 

[Marshall Barton]

Marshall! You're my favorite person right now It
worked and I appreciate your help so much.

That's nice Erica, glad I could help out.
--
Marsh
MVP [MS Access]

-----Original Message-----

Hello. I have a report that groups on Claim #. I have a
Group Footer in which I would like the sum of the Losses
Paid per group to display at the end of each group. If I
add a text box bound to Losses Paid field to the group
footer and set Running Sum property to Over Group, I only
get the value of the last Losses Paid in the group, not
the sum of all of them. Any ideas on why this might be?
Or ideas on a better way to get totals per group?

The RunningSum text box would have to be in the detail
section with the group footer text box referring to the
detail section text box. But there might be an easier way
to calculate the total.

Instead of using RunningSum, I think you can get what you
want just by using the expression =Sum([Losses Paid]) in
your group footer text box.