Query Question

[DoDo1975]

I have 3 queries which build an end query which contains all the information I want to display to the user. I would like to display this information in another query, but change the way it looks.

This is what I have now in the final query,

Site Name, Site Abbreviation, Sample ID, Sample Type, Analyte Name, Value, Standard

Basically this query has looked at each site, and pulled out all the samples within that site to look at. Each sample has entries for multiple different analytes. Then the query has looked up a standard for each analyte and ommited any records where the standard < value. I want to make a query that now displays all this information in the way I want. I would like it to look like a spreadsheet with the following columns.

Site Name, Site Abbreviation, Sample ID, Sample Type,

In the final columns I would like to list each analyte beside its standard, with the value and standard below in each row.

Can anyone help me do this. It is like a crosstab query with two colum headings, and two values and without performing any aggregate function on the values.

Thanks to any who can help.

Joel Lindsay
Vancouver BC

 

[DoDo1975]

To the top