SQL Function that returns the average (arithmetic mean) of the numeric values returned by a SELECT query.

      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.
(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-2016
Some rights reserved