C
Cydney
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?
--
Thank you, cs
~~~~~~~~~~~~~~~~~~~~~~~~
"What lies behind us and what lies before us are tiny matters compared to
what lies within us."
~ Ralph Waldo Emerson
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?
--
Thank you, cs
~~~~~~~~~~~~~~~~~~~~~~~~
"What lies behind us and what lies before us are tiny matters compared to
what lies within us."
~ Ralph Waldo Emerson