access 97 table / query extract fields to make columns?

[Guest]

Please help…I’m tearing my hair out with this! I have access 97, and a table
of data from a laboratory.

Each record has the fields site id, a date, a time, an analysis determinant
code number and a result of the analysis. The records may have the same site
id, date & time but a different analysis determinant code and analysis result
(ie a sample taken same date / time but being analysed for say 5
determinants). Also, other records may have different site ID’s, date time
det code and results.

I would like to end up with a table where I have a the site ID, date, time,
then each of the column’s after that contain the results for all the dets
analysed for that particular site / date / time!

I don’t have much experience in SQL…..!

Any help much appreciated.
Ta

 

[Bill Mosca, MS Access MVP]

Peter

That's exactly what you DO NOT want to do. If you create a table like you
describe, you are denormalizing the table you already have. If you want to
see the data displayed as you describe in a form, you can use a sub form. If
you want to see it in a report, use a group header for the site ID, date,
time. Put the rest of the fields in the detail section.