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:

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!