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.

🚀

Create your first interactive demo in minutes

No credit card required • Start building today

Start free

    This website uses cookies to enhance the user experience.

    AcceptDecline