In an Access report that contains numbers, you can use totals, averages, percentages, or running sums to make the data more understandable. This tutorial describes how to add totals to your reports. The total rows perform a calculation on an entire field of data.
How to add Totals in Reports in Microsoft Access
There are two methods to add totals in reports in Microsoft Access:
- Add a Total in the Layout view
- Add a Total in Design View
1] Add a Total in the Layout view
The Layout View method is the easiest way to add totals to your reports.
On the Navigation Pane, right-click the report and then click Layout View.
Click the row under the field (column) you want to calculate; for example, Amount Paid.
On the Report Layout Design tab, in Grouping and Totals group, click Totals.
Click the type of aggregate that you want to add to your field.
Access adds a text box to the Report Footer section and sets its Control Source property to an expression that performs the calculation you want.
2] Add a Total in Design View
The Design View method gives you more control over the placement and appearance of your totals.
On the Navigation Pane, right-click the report and then click Design View.
Click the row under the field (column) you want to calculate; for example, Current due.
On the Report Design tab, in Grouping and Totals group, click Totals.
Click the type of aggregate that you want to add to your field.
Access adds a text box to the Report Footer section and sets its Control Source property to an expression that performs the calculation you want.
If you want to see the full calculation, open the report in Layout View.
We hope this tutorial helps you understand how to add totals in reports in Microsoft Access; if you have questions about the tutorial, let us know in the comments.
Read: How to add or delete a Field in Design View in Access
How do you add a total to an Access report?
To add totals to your reports, you have to click the column where you want the calculation, then click the Totals button; the Totals row allows you to add up an entire column of numbers and the result appears in a row at the bottom of the table.
How do you create a calculation in Access report?
To create a calculation in the Access report, you need to follow one of the two methods mentioned above. It is possible to add the calculation in Layout and Design view. First, you need to select the row or column you want to calculate and click on the Totals option under the Grouping and Totals group.
