Create Databases: Add Totals and Subtotals in Access


show more Adding totals and subtotals to a report provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Essential Training show less
please wait ...

Adding totals and subtotals to a report

When reading a report, it's useful to be able to summarize the data with mathematical calculations, both for subsections the entire report itself. Access 2010's Totals button makes it easy. Scroll down in your Navigation Pane, to your Reports object, and right-click on Orders by Customer and open it in Layout View. We'd like to know how much each customer has spent with us and how much revenue we've also had for that report period. Click on the Total column, and then up in the Report Layout tools on the Design Ribbon, click on Totals, right here, and choose Sum.

A subtotal has been added below every row. Now it's a little short. Click on it and pull the bottom down a little. Now scroll down to the bottom of the whole report. You'll see we have a grand total down here. Make the same adjustment, so that it's a little bitter. Now go up to the Report Layout tools, and click on the Format Ribbon. Let's click on this Dollar sign, which will change our grand total to...

Adding totals and subtotals to a report
Video duration: 2m 58s 3h 30m Beginner

Viewers:

Adding totals and subtotals to a report provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Essential Training

please wait ...