Searched still need help :( Standard dev

[JTQ911]

In one record (or row?) there I have 10 fields (columns), how can i find the standard deviation of those 10 numbers. Seems to only want to be able to do standard deviation if all data is in one field or column. I tried doing a query but same thing, if all the fields are across, it doesatn find the standard deviation of them. Please help this worthless access user. Thank you, I look foward to all the help I can get. As you can see, I still am struggling with even terminology. Excel is easy to me, access is a challenge to say the least.

 

[RuralGuy]

And as you have discovered, Access likes elements in records or rows rather than fields or columns. Without normalizing your data you may want to explore CrosstabQueries.

 

[JTQ911]

So if i have ten fields labed Value 1, Value 2..... Value 10, using the cross tab query how would i get it so that the query returns it in one column. once i get a query to return it as one column i want to find the standard deviation of the values in another form.

 

[RuralGuy]

There is a CrossTab Query Wizard that should be able to help you create the query. I have very little experience with these queries so maybe someone else will drop by to lend a hand.