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!

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



Vanderghast, Access MVP



<(E-Mail Removed)> wrote in message
news:69e65ffb-dc21-40c8-ad18-(E-Mail Removed)...
> 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!

WHOA! Thanks, Michel!!!

On Mar 7, 12:30*pm, "Michel Walsh"
<vanderghast@VirusAreFunnierThanSpam> wrote:
> * * (column1 ^ 2 + column2 ^ 2 - 0.5* (column1 + column2) ^ 2 *) ^ 0..5
>
> Vanderghast, Access MVP
>
> <jl...@marzetti.com> wrote in message
>
> news:69e65ffb-dc21-40c8-ad18-(E-Mail Removed)...
>
>
>
> > 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!- Hide quoted text -
>
> - Show quoted text -