Mike: Try: select count(Field), sum(field), sum(Field^2) INTO .. FROM Tbl WHERE ..
This gives what you need for calculating STDEV/VARIANCE. Easier than a loop. Jim Blackburn Kodiak Ramsour Mike wrote: > > I currently use AVG, MAXIMUM, and MINIMUM for > some of my analysis but then I have to use a loop to calculate the STDEV. > Or am I missing something? > > Thanks >
