Statistics using multiple fields in the same record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table of statistical data points per part number. I would like to
use the statistical functions accross the fields in the same record, but the
function wants a string expression for the name of a field. How do I
represent 10 fields in the same record, each with a different field name.
e.f. p1,p3,p3......


TIA
Lee Hunter
 
In order to use the StdDev and other aggregate functions, you'll need to get
the data into the same column. This is what is referred to as 'data
normalization'.

You can fake it with a big fat UNION query.
 
Thanks Steve,

Based on your input, I decided it was best to use automation to feed the
columns as an array to the Excel worksheet statistical functions. That way i
can use Excel to do the necessary charting and graphing, while using Access
to hold the data and do whatever queries are necessary.

I appreciate your help.
Lee
 
Back
Top