From the course: Access 2016 Essential Training

Unlock the full course today

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

Obtaining summary statistics

Obtaining summary statistics

From the course: Access 2016 Essential Training

Start my 1-month free trial

Obtaining summary statistics

“

- Most queries return a record set which is a temporary table of all of the records that match your chosen criteria. Once you've gathered your records together, you can tell Access to provide some summary statistics about the records that's gathered. This is called a totals query. Let's see how we can use one to gain some insight into the performance of the Landon Hotel from month to month. I've already started a query that we can begin with called the MonthlyRevenueSummary. Let's go ahead and find it in the navigation pane and right click on it and choose to open it into Design View. Here we can see we have two different tables assigned, we have the RoomAssignments and the RoomRates tables. From the RoomAssignments table, I've pulled down the CheckInDate column here. I also have two calculated columns, one is getting the year and the month. If you're curious on how these are working, just right click on it and say "Zoom." That'll bring it into a new Zoom box. We can change the font…

Contents