How to Create Running Totals in Reports MS Access
This is the most straightforward method for creating running totals. Follow these steps:
- 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.
This website uses cookies to ensure you get the best experience on our website. Learn More
Got it