How to show a running balance in my Grouped Report

[Lkwdmntr]

Hello guys,

I have a database that is used for the treasurer of a group. Everything is working well with the exception of the reports. I have the report grouped by month and would like to have a running balance in the footer of each grouping(month). Right now it only gives the amount total for each month, which is not what I need.

I attached the database so you can see exactly what I mean. It's pretty self-explanatory.

Thanks

 

[pbaldy]

Make a copy of the AccessTotalsAmount1 textbox and set its Running Sum property to Over All and see if that gets you what you want.

 

[Lkwdmntr]

I am not familiar with the "Running Sum" property, or the "Over All" condition. Perhaps give an example or make the changes in the database and attach the updated file.

 

[Lkwdmntr]

Never mind, I just figured it out. Works great, thanks so much.

 

[pbaldy]

Happy to help!