All Functions WHERE Clause HAVING Clause GROUP BY Clause FUNCTION: STDEVP SELECT STDEVP(field) AS [expression] FROM table [WHERE ...] [GROUPBY ...] [HAVING ...]   The STDEVP 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, SUM, VAR, VARP. Note that all of these functions return a single value.   The STDEVP function finds the standard deviation by using all of values in a field. In comaparison, the STDEV function only uses a protion, called a sample, of the values to calculate the standard deviation. 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 standard deviation of the age for all MediCare patients in a hospital and stores that information in DevAge.   SELECT STDEVP(Age) AS [DevAge] FROM MediCarePatients Copyright 1999-2001 by Infinite Software Solutions, Inc. All rights reserved. Trademark Information