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 Button image .

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