Combine several queries

[JCAA]

I need to combine 3 different cross tab queries into one. They do not have the same column headings and I need all the column headings in the result. They all consist of the same rows. Is there a way I can write a query that sum up the total from each column heading and have all column headings in the result?

Hope this makes sense...

Thanks,

JCA

 

[dhookom]

You can add values to the column headings property of the query. There is a FAQ on how to create crosstabs with multiple values faq701-4524.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.