How to show a running balance in my Grouped Report (1 Viewer)

Lkwdmntr

Registered User
Joined
Jul 10, 2019
Messages
188
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
 

Attachments

pbaldy

Wino Moderator
Staff member
Joined
Aug 30, 2003
Messages
33,617
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

Registered User
Joined
Jul 10, 2019
Messages
188
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.
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom