Download PC Repair Tool to quickly find & fix Windows errors automatically 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. There are two methods to add totals in reports in Microsoft Access: The Layout View method is the easiest way to add totals to your reports.1] Add a Total in the Layout view
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.
How do you add Totals in Access?
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.
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.
Shantel is a university student studying for Bachelor of Science in Information Technology. Her goal is to become a Database Administrator or a System Administrator. She enjoys reading and watching historical documentaries and dramas.