Avg Function (SQL Only)

See AlsovbfctSQLAvgSee                 ExamplevbfctSQLAvgEx>Low


Calculates the arithmetic mean of a set of values contained in a specified field on a query.


Avg( expr )


The Avg function uses the following argument.

Argument        Description


expr                 String expression1330R89 identifying the field that contains the numeric data you want to average, or an expression that performs a calculation using the data in that field.  Operands in expr can include the name of a table field, or a Visual Basic function (which can be intrinsic but not a user-defined function or one of the other domain aggregate or SQL aggregate functions).


The average calculated by Avg is the arithmetic mean (the sum of the values divided by the number of values).  You might use Avg, for example, to calculate average freight cost.

The Avg function doesn't include any Null fields in the calculation.