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
I do not follow your explaination of '3-Tier' but if you post sample data,
SQL of a select query to pull the data, and an example you how you want the crosstab to look like then someone might be able to propose a suggestion. -- Build a little, test a little. "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 | |
|
|