How to totals query.
A Totals query is a special kind of query that allows you to group records by a field or a group of fields. Totals query is used most frequently to perform calculations on groups. For instance, you might want to subtotal all the sales by region. In this case, you would create a query that contains the region and sales total fields, group by the region, and sum the sales total field. You can create a Totals query by choosing View, Totals in the query design grid. Then, select an aggregate function in each field's Total cell. Be aware, though, that when working with a Totals query, Access sorts the result, even if you don't specify a sort order. Since Access must group the underlying records, this behavior might seem obvious, but it's easy to miss if you don't realize it's happening.
PCMag reviews products independently