SQL aggregate functions (SQL)

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