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.

Obtain summary statistics

Obtain summary statistics

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

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. We'll start by creating a new query in Design view. Now, I wanna find out how many guests that a hotel had for each month that we have data on. To find this out, we need to first collect some raw data, and we can find that in the "RoomAssignments" table. Let's go ahead and close the Show Table window. We'll need the check-in date column to know the day that the guest checked into the hotel. I'll also grab the "AssignmentID" column, which is at the bottom. This'll help us count up how many check-ins occurred on each day and month, in just a moment. For this query, we're not concerned with who visited the hotel, so we don't need to pull in the guest table at all, If I go ahead and run this query…

Contents