Running Sums for Groups

  • Thread starter Thread starter ehale
  • Start date Start date
E

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!
 
ehale said:
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?
Click to expand...

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! You're my favorite person right now :) It
worked and I appreciate your help so much.



-----Original Message-----
ehale said:
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?
Click to expand...

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.
Click to expand...
 
erica said:
Marshall! You're my favorite person right now :) It
worked and I appreciate your help so much.
Click to expand...

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

-----Original Message-----
ehale said:
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?
Click to expand...

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.
Click to expand...
Click to expand...
 
Back
Top