Functions you can use in a calculated field
A function
returns a value based on the results of a calculation or other operation. For example, the
SUM function returns the sum of two or more values. Microsoft Query supports the following functions. The actual functions available for a
data source
depend on the ODBC driver
for the data source. To see what functions are available for your data source, click a numeric
field, and then click Cycle through Totals 
.
| To return this value | Use |
|---|---|
| The average of a set of values in a field | AVG |
| The total number of records | COUNT |
| The maximum of a set of values in a field | MAX |
| The minimum of a set of values in a field | MIN |
| The sum of a set of values in a field | SUM |