The Avg function calculates the average value of a column of numbers.  The average value of a column is equal to the sum of the values divided by the number of values.

Syntax

Avg([column])

  • column (required) - the column of numbers that is evaluated for the average.

Example

Avg([Profit])

  • Calculate the average profit in a group.

Avg([Population 2010] - [Population 2000])

  • Calculate the average change in population in a group.