Formulas for Std deviation and average %

B

Brian

I am needing to create formulas to figure out Std.
Deviation and Average % from three different fields. COuld
you please assit me with this? Thanks!
 
R

Ron Weiner

Standard Deviation and Average are functions that are already built into
Access Sql (and most other Sql dialects). You can use them in a totals
query. Here is an example:

SELECT StDev(YourField) as StdDevOfYourField
FROM YourTable
WHERE SomeField = SomeCondition

Don't attempt to re-invent the wheel. Just grab one from the pile when you
need one.

Ron W
 
Top