Standard Deviations query

[Dave Smith]

I was assuming that this would be something I could find on the web, but I'm just not finding it I'm not.
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 isn’t working.
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?

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

or something like this:

(DStDev([Jan_Fund],[Feb_Fund],[Mar_Fund]))

or

(StDev([Jan_Fund]),([Feb_Fund],[Mar_Fund]))

Thank for all your help

TCB

[Rabbit]

You can't calculate the standard deviation of multiple fields, well... Access can't anyways. You will have to unpivot your data and then calculate the standard deviation from one column or calculate the standard deviation of each column separately. It all depends on what you want.

[ADezii]

I've actually created some 'Rogue' Code that will calculate the Standard Deviation for Values existing in Multiple Fields (Jan, Feb, Mar,...Dec), for Multiple Records, to 2 Decimal Places. The Code utilizes a Calculated Field in a Query, a Public Function, and simple Automation Code to let Excel do all the work. It has been tested and is functional, but with a large number of Records will be very slow to process. I'll only post the Code if you are interested.