Aggregate Queries in MS Access - Office 365

An aggregate query or group by query is a type of query you can build to help you quickly group and summarize your data. Summary queries perform a mathematical function, called an aggregate function on a field based on groups of values found in another grouped query field or fields. This video explains in detail how to create aggregate queries in MS Access.