Combine Crosstab query with Table to export together to Excel

[kattatonic1]

I have the following:



1) Crosstab query grouped by Branch
2) Table whose first column is Branch

I can't seem to combine them. I want to combine them for export to Excel together. Users use the data together. I can of course have them export them separately and then combine in excel but it seems it should be easy enough to export them together given the Branch columns match.

Any help would be apprecited.

Kay in Toronto
All thunderstormy today

[kattatonic1]

Or... could they at least end up in the same workbook on different worksheets perhaps?

[June7]

Why can't you join crosstab to table? - works for me - and exports to Excel perfectly.

[kattatonic1]

June7, sorry to waste your time. Can we say Brain Fart here? I just tried it again after your comment, and it's just dandy. Duh. Time for a weekend. Embarrassing. Many thanks for prodding me.

Kay