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

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.

--
Bill Mosca, MS Access MVP


"Peter" <(E-Mail Removed)> wrote in message
news0DAF02E-4455-4AE0-817B-(E-Mail Removed)...
> 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
>