Standard Deviations in a query

[TBC]

How would I get I use a query to get the Standard Deviations?

from what I read it should be something like this, but this one isnt working.

Standard Deviations: Val(StDev ([Jan_Fund],[Feb_Fund],[Mar_Fund],[Apr_Fund],[May_Fund],[Jun_Fund],[Jul_Fund],[Aug_Fund],[Sep_Fund],[Oct_Fund],[Nov_Fund],[Dec_Fund],0)

Thank for all your help

TCB

 

[vbaInet]

StDev is for column-wise calculations where you set only one field. What you need to use is DStDev()

 

[TBC]

Thanks vbaInet, But I still don’t know what I need to do to get Standard Deviation for my months that funded.

When I try this

Standard Deviations: (DStDev([Jan_Fund],[Feb_Fund],[Mar_Fund]))

I'm getting a reading in the SD field that shows "#Error"

So if I took all the months from Jan - Dec, what would the formula be for a Standard Deviation?

I was assuming that this would be something I could find on the web, just I'm not. Can you help me figure this out?

Thanks for all your time and help

 

[vbaInet]

Check the help files for the correct syntax of the DStDev() function.

 

[TBC]

Would you recommend a sight?

 

[vbaInet]

You don't really need a website to know the correct syntax of DStDev. Just look in the Access help file where the vba editor is, press F1 key to bring up Help.

 

[boblarson]

The problem is that none of these is going to work for you because you are attempting to use multiple columns. They all work on ONE column of data. You would need to have a grouping query which pulls the data, grouped on a year/month field, in one column instead of breaking it out by each month in a column.