Combining Results of Cross Tab Queries

[kkyork]

I have two cross tab queries which I am trying to combine into a logical format.

In the first, I have two row headings - employees & type of hours (billable/non-billable). My column headings are the months. The results are the sum of each hour type for the employees.

In the second, I have one row heading, employees. My column heading are the months. The results are the sum of the available employee hours.

I'd ideally like to have the second crosstab query results, end up as another row heading in crosstab 1 - i.e. employees & type of hours (billable/non-billable/available).



Any idea how I can accomplish this? I've tried a couple of different approaches without any luck.

Thanks in advance!

[June7]

You tried a query that joined the two crosstabs? The total hours should repeat for each of the hour type codes.

[recyan]

Was wondering if we could try to get the results in a query first & then convert that in to a cross-tab query
instead of
combining 2 cross-tab queries ?

Thanks

[kkyork]

I tried combining the two but always end up with something that looks like this:

	HourType	HourType	Jan.Utilize	Jan.Available	Feb.Utilize	Feb.Available
Employee 1	Billable	Available	80	100	70	150
Employee 1	Non-Billable	Available	20	100	80	150

Whereas I desire to have it look more like this:

	HourType	Jan.Utilize	Feb.Utilize
Employee 1	Billable	80	70
Employee 1	Non-Billable	20	80
Employee 1	Available	100	150

I have not tried just querying both sets of data and then doing one cross tab. Had really only attempted joining the two.

[kkyork]

Used a union query to combine the data into one table and now ran a cross tab query on that! Works perfectly. Thanks for the pointer!