From the course: Access 2019 Essential Training

Unlock the full course today

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

Obtain summary statistics

Obtain summary statistics

From the course: Access 2019 Essential Training

Start my 1-month free trial

Obtain summary statistics

“

- [Instructor] Once you've gathered a number of records with a query, you can then tell Access to provide some summary statistics about those records. 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. To do that, we'll go up and create a new query in Design view. Now, I wanna find out how many guests the hotel had for each month that we have data on. To find this out, we need to collect some raw data, and that'll come out of the RoomAssignments table. Let's go ahead and double-click on that, and then close the Show Table window. We'll need the Check-in Date column. I'll go ahead and double-click on that to add it into our grid, and this will tell us when the check-ins occurred. I'll also grab the AssignmentId column, which is at the bottom. This will give us a unique identifier for each record. This will help us count up how many check-ins occurred on each day and month in just a moment. For…

Contents