From the course: Building Solutions Using Excel and Access 2019 Together
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Calculate totals in Access queries
From the course: Building Solutions Using Excel and Access 2019 Together
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…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.