SQL Aggregate Functions (SQL)

Office 2013 and later

Last modified: June 29, 2011

Applies to: Access 2013 | Office 2013

Using the SQL aggregate functions, you can determine various statistics on sets of values. You can use these functions in a query and aggregate expressions in the SQL property of a QueryDef object or when creating a Recordset object based on an SQL query.

Avg Function

Count Function

First, Last Functions

Min, Max Functions

StDev, StDevP Functions

Sum Function

Var, VarP Functions