How to Create Running Totals in Reports MS Access
- George Apostolov
- 05 Sep 2025
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.
Create your first interactive demo in minutes
No credit card required • Start building today


