How to Create Running Totals in Reports MS Access

Guide

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.