SQL function
Using the SQL function, you can directly calculate the average, total number, minimum, maximum value, sum, standard deviation, variation of variation, etc. These SQL functions can also be used when using the RecordSet object.
The SQL function includes the following:
AVG function: Calculate the arithmetic average of a particular field data in the query.
Count Function: Calculate the number of records that meet the query conditions.
Min, MAX function: Remove the information that meets the first, the topmost record of the query condition in the specified field.
First, Last Function: Remove the minimum, maximum of the query conditions in the specified field.
STDEV function: Calculate the standard deviation of the query condition in the specified field.
SUM function: Calculate the sum of the data in accordance with the query criteria in the specified field.
Var, Function: Calculate the number of variation estimates that meet the query conditions in the specified field.
