Calculating Standard Deviation of three fields in one record

D

DGauch

I'm trying to calculate an SD for three fields (Test 1, Test2, Test 3) of a
single record (Sample #). None of the SD functions seem to be able to handle
this calculation.

Do I have to manually create the STDev formula in Expression Builder or is
there a function I'm missing?

Thanks
 
M

Michel Walsh

Hi,


A relational database works vertically, not horizontally. If you have an
horizontal aggregate, you have to do it "by hand" (through VBA code, that
is).

Alternatively, use a normalized (intended) design, one where the data will
be vertical, under one column.


Hoping it may help,
Vanderghast, Access MVP
 
Top