Var, VarP Functions (SQL Only)
See Also Example
Return estimates of the variance for a population or a population sample represented as a set of values contained in a specified field of a query.
Var( expr )
VarP( expr )
VarP evaluates a population, and Var evaluates a population sample.
The Var and VarP functions use the following argument.
expr String expression identifying the field that contains the numeric data you want to evaluate, or an expression that performs a calculation using the data in that field. Operands in expr can include the name of a table field, or a Visual Basic function (which can be intrinsic but not a user-defined function or one of the other domain aggregate or SQL aggregate functions).
If the underlying query contains fewer than two records, Var and VarP return a Null (which indicates that a variance can't be calculated).