Stand Deviation Question

[GMFTM]

I have a query build Calculating the Days to Sell, now I need to apply the DStDev to this, however, new to this in access, did it in excel, but never in Access.

Days to Sell: Avg([Sale_Date]-[Secured_Dt])

This is what I need to apply the Std Dev to.

Can someone help me with the syntax?

 

[Marbles]

This might help:

DStdev and DStdevP Access Functions

 

[GMFTM]

I need to do this within a query. in excel it is the function and the group of data A1: A55 (example). In access you do not have the values yet so I need to know how to build the syntax to do that.

This might help:

DStdev and DStdevP Access Functions

 

[xenou]

In the Dxx() function you will use your query as the source for the values.

=DStdev("MyField","MyQuery")
where MyQuery is the name of your query and MyField is the field in the query that has the values you want the stdev for.

Funny that I never saw this function existed before.

 

[GMFTM]

Thank you even though I mis-spoke, instead of syntax I should have said expression.

In the Dxx() function you will use your query as the source for the values.

=DStdev("MyField","MyQuery")
where MyQuery is the name of your query and MyField is the field in the query that has the values you want the stdev for.

Funny that I never saw this function existed before.