Formulas for Std deviation and average %

[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!

 

[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