2 or more crosstab queries brought together with UNION

Originally Posted by garethfx

Hi all

Anybody had experience bring together 2 or more crosstab queries using the UNION?
ALL 3 crosstabs come from 3 sourcing queries from the same table so of course normally runnning 3 crosstabs at the sametime throws an error

I have to pull 3 crosstabs together. All are laid out as

The first is those number of people starting a training programme

Row
Training Programme

Heading
Period number. (This is set 1 to 12)

Then we have the above format but for those leaving and the third is for those number acheiving the training programme.
I will be able to set up a simple text box situation in a later report to show the % of leavers acheiving the training.

any ideas??