By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,956 Members | 1,683 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,956 IT Pros & Developers. It's quick & easy.

2 or more crosstab queries brought together with UNION

P: 49
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??
May 5 '07 #1
Share this Question
Share on Google+
2 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
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??
Can you post the sql of the three crosstabs so we can get a better idea what you are talking about. Also give more detail on the result you are trying to achieve.
May 5 '07 #2

P: 49
Ill look at the code on tuesday - I'm not in the office until then

many thanks for replying

Gareth
May 6 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.