Crosstab nightmare

[CycleMonkey]

Help! I've got myself in a position where my users need output in a format handy for copying into Excel. This has a series of year columns with about 14 rows. Due to the nature fo the data in the DB, I've had to create a corresponding crosstab query for each row in the Excel output format.

So now I have to try and pull all this together, ideally with a single set of year columns and all the corresponding row queries below.

Only way I can think of is a report with 14 sub-reports - one for each line.
Anyone got any ideas? Not sure I've explained it bery well....

 

[Pat Hartman]

You can create a union query.

Due to the nature fo the data in the DB, I've had to create a corresponding crosstab query for each row in the Excel output format

? are you sure?