Var, VarP Functions (SQL Only)

See AlsovbfctSQLVarSee                 ExamplevbfctSQLVarEx>Low


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.

Argument        Description


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