Converting Fields to Records??

  • Thread starter Thread starter Tinius Olsen
  • Start date Start date
T

Tinius Olsen

Have database where each record contain the following
fields:
[Product], [Count] -number of samples, and [D1],[D2],
[D3]... [D40] fields for measurement data.

Question, is their a way the measurement data [D1],[D2],
[D3]... [D40] can be converted or input into a table as 40
records to facilitate using Access's built in statistical
functions?
 
Well it is a bit tedious, but you could do an SQL
statement using UNION so:

SELECT [Product], [Count], [D1] FROM ...
UNION
SELECT [Product], [Count], [D2] FROM ...
UNION
SELECT [Product], [Count], [D3] FROM ...
....etc to [D40]
 
Back
Top