Hi,
I have a union query which joins two crosstabs. One crosstab is effectively the sum of the other, and I want a query to display the results of both, with the summing one underneath so it looks like a spreadsheet with sums calculated in columns.
a) is there a way to do this all in one crosstab, without the need for the summing one and the union query?
b) if not, what do I put in the order by clause so that it puts the row headings for one query first followed by the single row heading from the summing crosstab?
Thanks,
Stickers
I have a union query which joins two crosstabs. One crosstab is effectively the sum of the other, and I want a query to display the results of both, with the summing one underneath so it looks like a spreadsheet with sums calculated in columns.
a) is there a way to do this all in one crosstab, without the need for the summing one and the union query?
b) if not, what do I put in the order by clause so that it puts the row headings for one query first followed by the single row heading from the summing crosstab?
Thanks,
Stickers
