standard deviations and averages of columns

[gunwax]

please help!!! - standard deviations and averages of columns

I am wondering if there is a way to make a query count the number of rows displayed and then use that number for taking averages of values in a certain column. Also, I need to know how to make a column of values generate another column (or whatever output) showing the standard deviation and average of all the numbers in the column. How can I do this? Please help.

Gunnar

 

[Pat Hartman]

The avg() and stDev() functions are available in queries. Create a select query that selects the columns you need. Press the sigma icon on the toolbar to change to a totals query. Change the "Total" from "Group By" to whatever you want.

 

[KenHigg]

Gunnar

Do you know of any Access add on's that will do statistical control charts like sigma limits and histograms?

kh