Avg

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.

Examples

In a query:

AVG

In VBA:

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

Related:

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 © 1999-2024 SS64.com
Some rights reserved