Join 2 Queries

[aftabn10]

Hi,

As I have been told it is not possible to have two transform queries. What I have done is wrote two queries. One which gives me a count value and the other gives me a time value. The problem I am having is that I would like to combine these 2 but for the values to appear next to each other:
For example:

EIN | Total Agent Work | Total Time | Queue 1 |

1 | 10 | 04:30 | 2 | 01:30 |

Even if its possible for me to have the Queue Name appear twice alongside that would be fine.

Could somebody please help?

Here are my 2 queries.

TRANSFORM Sum(daily_effectiveness.JOBTIME) AS SumOfJOBTIME
SELECT daily_effectiveness.EIN, Count(daily_effectiveness.JOBTIME) AS [Total Agent Work], Sum(daily_effectiveness.JOBTIME) AS [Total Time]
FROM daily_effectiveness
GROUP BY daily_effectiveness.EIN
PIVOT daily_effectiveness.ORBITQUEUE;
 
TRANSFORM Count(daily_effectiveness.JOBTIME) AS CountOfJOBTIME
SELECT daily_effectiveness.EIN, Count(daily_effectiveness.JOBTIME) AS [Total Agent Work], Sum(daily_effectiveness.JOBTIME) AS [Total Time]
FROM daily_effectiveness
GROUP BY daily_effectiveness.EIN
PIVOT daily_effectiveness.ORBITQUEUE;

Thanks in advance.

 

[aftabn10]

Thanks for your reply Pat. I have managed to write a third query to combine the 2 crosstabs, but the problem I am having is that I get all the count and sums within the queue column which means alot of scrolling. How could I have the values alongside each other?

Thanks for your help.