SQL Function that returns the average (arithmetic mean) of the numeric values returned by a SELECT query.
Syntax Avg (expression)
Use the Avg function in the access query builder by clicking the Totals toolbar button:
The Avg function is used in conjunction with the Group By clause.
Select Avg(Salary) from T_Employees Group By Department;
“Gold is the money of kings; silver is the money of gentlemen; barter is the money of peasants; but debt is the money of slaves” ~ Norm Franz
DAvg - Average from a set of records.
Median function for access - MSDN
Count (SQL) - Count records
Max (SQL) - Return the maximum value from a query.
Min (SQL) - Return the minimum value from a query.
Partition (SQL) - Locate a number within a range.
Sum (SQL) - Add up the values in a query result set.
© Copyright SS64.com 1999-2013
Some rights reserved