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

Lkwdmntr

Registered User.
Local time
Today, 04:05
Joined
Jul 10, 2019
Messages
193
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
Local time
Today, 04:05
Joined
Aug 30, 2003
Messages
33,796
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.
Local time
Today, 04:05
Joined
Jul 10, 2019
Messages
193
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

Registered User.
Local time
Today, 04:05
Joined
Jul 10, 2019
Messages
193
Never mind, I just figured it out. Works great, thanks so much.
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 04:05
Joined
Aug 30, 2003
Messages
33,796
Happy to help!
 

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

Top Bottom