running sum in report question (1 Viewer)

[RpbertS]

Hi I'm using running sum to get a total in the detail of one of my reports, how do I only get it to show the last value (the highest one), and not one after every field?

should I move the detail into another kinda of grouping? its getting a little confusing now.

thanks for any help,

 

[chrismcbride]

If you don't want to show a sum after each record, then you don't need a RunningSum. What you need is a plain old every day Sum. Place a Text field in the group footer of your report. If the control you would like to calculate the sum for is a simple table field, then set the text field's ControlSource to... =Sum([field_name])
If the control that you want to Sum is a calculated field then copy the calculation into the ControlSource of the new field and surround the whole mess with Sum().
Hope this helps...
Chris