From the course: Access 2019 Essential Training
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Creating calculated totals
From the course: Access 2019 Essential Training
Creating calculated totals
- [Narrator] So far, our CheckInAnalysis report has organized and grouped the records that were gathered by the CheckInAnalysis query. We can also add some statistical information about each group right inside of the report. This will give you some quick grand total figures that can help in understanding the data and making comparisons across days. Right now, the report is opened up in the Report View. I'm gonna come over here to the View button, and we're going to switch it over to Layout View. Now, before I get any further, though, I do want to open up the Group & Sort section, and I'm gonna remove the group that we have here on Type. Just go ahead and select it, and then press the x in the far right-hand side. That'll give us a slightly different look to this report, but it'll give us larger areas that we can aggregate across. Now this report is organizing everything based off of the day of the week, and we can see, for instance, on Sunday, that the Manchester King Suite is…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.