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.
Aggregate Queries in MS Access - Office 365
Теги
Aggregate Queries in MS AccessGroup by specified fieldSUM of specified fieldAverage of a group of valuesFirst value of a groupLast value of a groupMinimum value of a groupMaximum value of a groupCount of values in a groupCriteria for a summary fieldCriteria for a group by fieldSort the summary fieldsGroup by multiple fieldsLeft to right sort of summary fieldsSum of calculated fieldsMS AccessFind Easy Solution