I expect it can be done in one crosstab and one append query.

Post the SQL of your crosstabs.

--
Build a little, test a little.


"dtoney" wrote:

can you append the results of several crosstab queries into 1 table?

I'm calc different categories & customers and need to capture "hours" for
each area for several different categories:

Estimates
received - on time? avg days to certify
rejected
certified

Scheduling
received - on time? avg days to certify
rejected
certified

If I could append the results of these several categories into one table, I
could export into Excel, produce my graphs, and go on about my business....

any ideas?