3-Tier Crosstab Report

D

DT

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?
 
K

KARL DEWEY

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

3-Tier Crosstab Report 0
3-tier Crosstab Query & Report 0
3-Tier Report using Crosstab Query 0
3-Tier Crosstab Report 7
report from crosstab query 4
Report totals by day of week - from crosstab report 10
Query/Report on a Many to Many Relationship 0

Top