Combining Two Cross-tabs or Similar

[bretto7117]

I have two crosstabs the I'm trying to bring them together and sum by day. The only problem is they each contain different dates in each crosstab Querie. Is it possible to do some sort of Union Query on this?

 

[bretto7117]

essentially this is what that data will end up needing to go in

 

[theDBguy]

Hi. Welcome to the forum! How about UNIONing the two data sources first before doing a crosstab with all the data together? Will that work?

 

[bretto7117]

hey DBguy, yeah I'm trying that. I'm looking at some youtube videos to help and try to figure that out.

 

[theDBguy]

hey DBguy, yeah I'm trying that. I'm looking at some youtube videos to help and try to figure that out.

Okay. If you need more help, maybe you could post as sample db, so we can give it a try as well.

 

[bretto7117]

Okay. If you need more help, maybe you could post as sample db, so we can give it a try as well.

I just ended up dumping both Queries into 1 table and did a crosstab from that. The only problem with that is having to dump the data by hand.

 

[theDBguy]

I just ended up dumping both Queries into 1 table and did a crosstab from that. The only problem with that is having to dump the data by hand.

If it can't be avoided, maybe you can automate it. Just a thought...