From the course: Access Essential Training (Office 365/Microsoft)

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Create calculated totals

Create calculated totals

From the course: Access Essential Training (Office 365/Microsoft)

Start my 1-month free trial

Create calculated totals

- [Instructor] So far, our check in analysis report has organized and grouped the records that were gathered by the check in analysis query. We can also add some statistical information about each of these groups right inside of the report. That'll give us some quick grand total figures that can help in understanding the data and making comparisons across days. Right now I've got the report opened up in the report view, let's go ahead and switch it over into layout view, then I'm gonna come over and click in any of the cells in the total revenue column. On the design tab of the ribbon we'll come to the grouping and totals section and click on the totals button. This'll reveal a listing of aggregate functions and we've previously saw these when working with queries. I wanna get a sum total of the revenue across each group so I'll press the sum button and that'll add in a new totals row below each of these groups. This value is just gonna be the sum total of the values within the group.…

Contents