Converting Fields to Records??

[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?

 

[Ken reay]

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]