**Var, VarP Functions (SQL Only)**

__See Also__ __Example__

**Description**

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.

**Syntax**

**Var(** *expr* **)**

**VarP(** *expr* **)**

**Remarks**

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