__See Also__ __Example__

**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 expression__ 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.