Combine cross tab query

[21Aberdeen]

Hi

I hope to get help in how to combine 3 cross tab queries values into one daily progress report, transpose format. The values from each crosstab query are 1) Spent hours 2) Qty installed 3) Earned hours.

Attached are screenshots of the queries.

Thank you

 

[AlexHedley]

You could UNION the three data sources the create a CROSSTAB from that Query.

 

[21Aberdeen]

Thank you Alex,
Can you show me how this to be done, preferably in query design format please.

 

[AlexHedley]

You can create the Queries you need in the Query Builder.
Make sure they have matching columns, they do t have to be the name names but have the same type of info.

This article should be useful.

http://office.microsoft.com/en-gb/a...-by-using-a-union-query-HA010206109.aspx#BM2a

SELECT field_1[, field_2,…]
FROM table_1[, table_2,…]
UNION [ALL]
SELECT field_a[, field_b,...]
FROM table_a[, table_b,…];

 

[21Aberdeen]

Thank you Alex, today I learnt something valuable from you.
Cheers