Calculations not computing...I don't knwo how to do this!

[Randy U]

I am having issues making calculations in a report. I have 2 groups of 6 text boxes that contain numeric values on the form. From each of those groups of six I need to extract an average and a standard deviation (StDevP).
How can I do this on the report level without having to go into complicated queries?
Can anyone help me?

 

[KenHigg]

Are the 6 values you need stddev on in one record, (6 different fields), or are they stored in different records?

kh

 

[Pat Hartman]

If the values are in separate rows, you can use SIMPLE queries because Access supports the functions you need. However, if your data is unnormalized and so the values are in the same row, you're in for some code since you'll need to write your own standard deviation function.

 

[Randy U]

The values are in different "columns" of the same row in 1 table.
Can someone help me with the proper code?

 

[Pat Hartman]

You seem to have designed your table as if it were a spreadsheet. You have a choice,
a. redesign the table so it is properly normalized and simplify your life. You'll find that Access is easy to use and very flexible.
or
b. continue to create spreadsheets and learn how to write VBA and experience a hassle with everything you want to do. You'll hate Access and curse its designers.

Access tables in datasheet view look very much like spreadsheets. Don't be fooled. The apperance is superficial. For starters, relational databases (of which Access is one, Oracle is another, SQL server is yet another) do not support "horizontal" ranges for their aggregate functions. Compare the simple Sum() in Excel and Access to see the difference.