How to Add Calculations in Report Footer MS Access
Adding calculations in the footer of a report in Microsoft Access involves using the built-in functions in Access and configuring the footer section of the report. Here's how to do it step by step:
- Open the report in 'Design View' to make modifications.
- Ensure the 'Report Footer' or 'Page Footer' section is visible.
- Drag a 'Text Box' control from the toolbox to the footer section.
- In the text box, specify the calculation you want to perform.
- Select the text box and set its 'Format' property to 'Currency' in the Property Sheet.
- Click on the label icon to add a label next to the text box to describe the calculation.
- Switch to 'Report View' to see how the calculation appears in the footer.
This website uses cookies to ensure you get the best experience on our website. Learn More
Got it