>
SQL Aggregate Functions
Description
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.
| SQL Aggregate Functions |
|
| Avg Function |
| Count Function |
| Min, Max Functions |
| StDev, StDevP Functions |
| Sum Function |
| Var, VarP Functions |
Specifics (Microsoft Access)
The SQL aggregate functions are similar to the domain aggregate functions, but they are used in different contexts. In Microsoft Access, you can use the SQL aggregate functions in an SQL statement that you create in the SQL view of the Query window, or in an SQL statement within Visual Basic code. Conversely, domain aggregate functions can be called directly from Visual Basic code.
You can use both SQL aggregate and domain aggregate functions in query expressions in the query design grid. SQL aggregate functions are most useful in totals queries and crosstab queries.
You can also use both types of aggregate functions in a calculated control on a form or report.