From the course: Access 2019 Essential Training
Unlock the full course today
Join today to access over 22,700 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.
Contents
-
-
-
-
-
-
-
-
-
(Locked)
Introducing reports3m 27s
-
(Locked)
The Report Wizard4m 37s
-
(Locked)
Edit a report in Design view6m 3s
-
(Locked)
Edit a report in Layout view5m 11s
-
(Locked)
Group and sort records5m 35s
-
(Locked)
Creating calculated totals2m 59s
-
(Locked)
Apply conditional formatting rules6m 2s
-
(Locked)
Create labels3m 31s
-
(Locked)
Adjust print settings3m 38s
-
(Locked)
-
-