3-Tier Crosstab Report

I need to create a query which when completed will popluate a report that has
a 3-tiered column layout. I have multiple Stations (numbered text field like:
PMW-8) where multiple Samples (numbered text like: ATA-001) were taken on
various Dates (Month/Year format). Those become my tiers. I need to identify
the total amount of each Parameter (Ferrous Iron, Methane, Sulfate, etc..)
that were Sampled on the various random Dates at each of the Stations.

Does anyone have a good example of this type of layout?

--
DT

A couple questions:
is there a 1:1 relationship between Sample and Date at a given station?
I hear you describing a crosstab with Parameters as the rows and
Station/Sample/Date combos as the columns. Can you live with this
transposed? ie Parameters as columns, Station/Sample/Date as rows?

"DT" wrote:

I need to create a query which when completed will popluate a report that has
a 3-tiered column layout. I have multiple Stations (numbered text field like:
PMW-8) where multiple Samples (numbered text like: ATA-001) were taken on
various Dates (Month/Year format). Those become my tiers. I need to identify
the total amount of each Parameter (Ferrous Iron, Methane, Sulfate, etc..)
that were Sampled on the various random Dates at each of the Stations.

Does anyone have a good example of this type of layout?

--
DT