When you work with queries, you will often be more interested in the bottom line than in individual records. A query can calculate information about a group of records in one or more tables. For example, you could create a query that finds the total amount of tea your company sold to China in 2017 or how much all that tea cost. The Total row lets you group and summarize information in a query.
The Total row normally is tucked away from view in the query design window—you can make the Total appear by clicking the Totals button in the Show/Hide group on the Design tab under Query Tools on the ribbon. Once the Total row is displayed, you can tell Access how you want to summarize the fields.
In this lesson, you will learn how to summarize information with a query.