Perform calculations in a query

What do you want to do?

Learn more about the ways to perform calculations in a query

Learn what each type of totals calculation (aggregate function) does

Use the Simple Query Wizard to create a query that calculates a sum, average, count, minimum, or maximum total on one or more groups of records

Use the query design grid to calculate a sum, average, count, or other total

Create a calculated field for custom calculations

See examples of calculations used as criteria

See examples of calculations used to update data

Not sure which choice you want?