# How to Create Running Totals in Reports MS Access

> 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.

Canonical: https://livedemo.ai/tutorials/how-to-create-running-totals-in-reports-ms-access/
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a3a1eab56e05a00fe10db/preview?step=1

## Steps

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