Using the Total row in query Design view, you can calculate the sum, average, count, minimum, maximum, variance, or standard deviation on values in one or more fields either for all the records in a query or for one or more groups of records. Using the Criteria row, you can also add criteria to affect the results of the calculation.
Note You can also use the Simple Query Wizard to calculate the sum, average, count, minimum, or maximum of the values in a field; but if you want to add criteria, you must use the query design grid.
Return to Calculate a sum, average, count, or other total on records in a query