These functions are valid only for use only in SQL expression of  record source and can not be used in a field, computed field, parameter expression or within label/report/request code.

 

Sum ([columnname])

Retrieves the total of the values in a field.

Avg ([columnname])

Retrieves the average of the values in a field.

Min ([columnname])

Retrieves the lowest value in a field.

Max ([columnname])

Retrieves the highest value in a field.

Count ([columnname])

Retrieves the number of values in a field, not counting Null (blank) values.

StDev ([columnname])

Retrieves the standard deviation of the values in a field.

StDevP ([columnname])

Retrieves the standard deviation/population of the values in a field.

Var ([columnname])

Retrieves the variance of the values in a field.

VarP ([columnname])

Retrieves the variance/population of the values in a field.

First ([columnname])

Retrieves the first entry that matches the criteria listed in the function.

Last ([columnname])

Retrieves the last entry that matches the criteria listed in the function.