# How to Add Calculations in Report Footer MS Access

> To add calculations in the report footer in MS Access, open the report in Design View, ensure the footer section is visible, and drag a Text Box control to it. Specify the calculation in the text box, set its Format property to Currency, add a descriptive label, and switch to Report View to view the result.

Canonical: https://livedemo.ai/tutorials/how-to-add-calculations-in-report-footer-ms-access/
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a2cbea98365d08657011f/preview?step=1

## Steps

1. Open the report in 'Design View' to make modifications.
2. Ensure the 'Report Footer' or 'Page Footer' section is visible.
3. Drag a 'Text Box' control from the toolbox to the footer section.
4. In the text box, specify the calculation you want to perform.
5. Select the text box and set its 'Format' property to 'Currency' in the Property Sheet.
6. Click on the label icon to add a label next to the text box to describe the calculation.
7. Switch to 'Report View' to see how the calculation appears in the footer.