Formulas for Std deviation and average %

  • Thread starter Thread starter Brian
  • Start date Start date
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!
 
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
 
Back
Top