Video: Calculate totals and subtotals in Access

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

Let’s say that you own a business or that your boss wants information on the total dollar sales for the last six months, Access offers several ways to calculate this kind of summary value. In this video, we’ll focus on methods that you can use to perform calculations on numeric data to get a summary value. We’ll examine how to use the Totals row in a datasheet, how to create a totals query, and how to group and summarize items on a report.

Next Steps

To learn more about using expressions in your calculations, see the following articles:

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.