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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Form: OrderBy minimum of fields 1
New record does not update all subforms 5
Annual Calendar 1
Adding values in to table for appropriate fields only 5
Worksheet program to convert parent/children data to string(s) 1
Simple (?) report? 2
How to get each table's first line of record and write into excel? 3
Converting Access 97 to Acees 2003 & get conversion Errors 1

Back
Top