How to Create Running Totals in Reports MS Access

Quick summary

This tutorial shows how to create running totals in MS Access reports using the Running Sum property on a text box control. By setting the Control Source and configuring Running Sum to Over Group or Over All, you can display cumulative field values across report records without writing custom code.

Steps

1. Open the report in Design View where you want to add the running total.
2. In the Report Design tab, click the Text Box tool and add it to the report detail section.
3. Click on the Property Sheet to open the control properties panel.
4. Set the Control Source for the Text Box to define which field it references.
5. Set the Control Source property to the specific field you want to create a running total for.
6. With the text box selected, go to the Running Sum property and set it to Over Group or Over All.
7. Save your changes by clicking the save icon.