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