How to Create Running Totals in Reports MS Access
- George Apostolov
How to Create Running Totals in Reports MS Access: step-by-step guide
Open the report in 'Design View' where you want to add the running total.
In the 'Report Design' tab, click on the 'Text Box' tool and add it to the report detail section.
Click on the 'Property Sheet'.
Set the 'Control Source' for the 'Text Box'.
Set its 'Control Source' property to the field you want to create a running total for.
With the text box selected, go to the 'Running Sum' property. Set it to 'Over Group' or 'Over All'.
Save your changes by clicking the save icon.
Quick answer: To create running totals in Reports MS Access, open the report in Design View, add a Text Box to the detail section via the Report Design tab, configure its Control Source property to the desired field, set the Running Sum property to Over Group or Over All, and save your changes.
About this tutorial
Calculate cumulative values easily in the app by adding a text box, setting its control source, and configuring the running sum property. This guide shows how to create Running Totals in Reports MS Access in 7 steps, starting with "Open the report in 'Design View' where you want to add the running total" and finishing with "Save your changes by clicking the save icon". The interactive demo above is a click-through copy of the real product interface, so you can rehearse each step before doing it in your own account.
Frequently asked questions
How many steps does it take to create Running Totals in Reports MS Access?
7 steps. Each one is listed in order above, and the demo highlights exactly where to click.
Can I try it without changing my own account?
Yes. Clicking through the demo doesn't touch your data or settings. Once you know the flow, repeat it in your own workspace.
Create your first interactive demo in minutes
No credit card required • Start building today
