All Functions WHERE Clause HAVING Clause GROUP BY Clause FUNCTION: VARP SELECT VARP(field) AS [expression] FROM table [WHERE ...] [GROUPBY ...] [HAVING ...]   The VARP function is one of the aggregate functions that are used to calculate statistical information for a specified numeric field in a query. The other aggregate functions are: AVG, COUNT, MAX, MIN, STDEV, STDEVP, SUM, VAR, . Note that all of these functions return a single value.   The VARP function finds the variance by using all of values in a field. In comaparison, the VAR function only uses a portion, called a sample, of the values to calculate the variance. There must be at least two values in the field or the standard deviation will not be calculated and a NULL value is returned.   This code finds the variance of the age for all MediCare patients in a hospital and stores that information in VarAge.   SELECT VARP(Age) AS [VarAge] FROM MediCarePatients Copyright 1999-2001 by Infinite Software Solutions, Inc. All rights reserved. Trademark Information