StDev

[jlute]

I'm pretty sure this can be done but I'm tripping over it. Isn't it
possible to perform a StDev calculation on 2 column value of 1 row?
For example:

ID | Column1 | Column2 | StDev
123 | 10 | 125 | 81.3172

How do I write this expression in the query? I know you need to make
an alias but after that I'm lost after trying several things.

Your help is greatly appreciated. Thanks!

 

[Michel Walsh]

(column1 ^ 2 + column2 ^ 2 - 0.5* (column1 + column2) ^ 2 ) ^ 0.5



Vanderghast, Access MVP

 

[jlute]

WHOA! Thanks, Michel!!!

    (column1 ^ 2 + column2 ^ 2 - 0.5* (column1 + column2) ^ 2  ) ^ 0..5

Vanderghast, Access MVP









- Show quoted text -