Video: Calculate totals and subtotals in Access

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:

• Add a calculated field to a table

• Build an expression

• Guide to expression syntax