Calculate totals in Access queries

- [Instructor] Even though the syntax may vary…for most of the calculations you build in Excel,…if you can build it in Excel,…you can typically build it in Access.…Let's create some total queries…which would be the equivalent of sum.…Our auto sum or auto average that you would find in Excel.…Let's make a copy of our short list.…I'll right click and choose copy,…and then I'll right click and choose paste.…Let's go ahead and name this count by department.…

There's my new count by department query.…I'll go ahead and double click it.…This already has all of the details that I need.…I just want to add the department name…and then I want count the people.…So I would do an auto sum in Excel,…but it would be a little bit of a challenge.…Maybe I would do a subtotal by department.…Let me show you how we do this in Access.…I'll go change to my design view.…I really want to show the department name,…so I'm going to go ahead and delete these three columns.…Let me just swipe it across,…and then I'll drag that department name into the list.…