Access 2000. Build expression STDev, 30 fields?

[Guest]

Need to calculate STDev for 30 fields in one record. I need an example please.

 

[[MVP] S.Clark]

An example of how to normalize it to a single column, such that you can
query that one column? Or something else?

 

[Guest]

I want the answer in one column in a query so that I can then use the answer
in a form/report.

 

[[MVP] S.Clark]

Ok. Create a new table with the single column. Create an append query, one
for every column in the multicolumn table., to write the data to the single
column table.

Then Perform your stats query from the single column table.

 

[Guest]

Steve, thanks for the info. Since I have 5 tables with a total of 190
fields, that means I would have to create 5 new tables and 190 append
queries. I think I will go back to the requestor and see if they really need
the STDev answer.

Thanks again.

 

[Douglas J. Steele]

You might be able to create queries that normalize the fields so that you
can calculate the StDev, rather than requiring new tables.

SELECT Field1
FROM MyTable
UNION
SELECT Field2
FROM MyTable
UNION
....

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)