If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
3-Tier Crosstab Report
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 |
Thread Tools | |
Display Modes | |
|
|