Avg Function (SQL Only)

See AlsovbfctSQLAvgSee                 ExamplevbfctSQLAvgEx>Low

Description

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

Syntax

Avg( expr )

Remarks

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.