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 |