Add Three CrossTab Queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have three crosstab queries that summarize results of three different
categories. I would like to add the three crosstab queries together. The
end result is a recordset with the appropriate sums in the cells of the
crosstab queries. How do I do this (in Access or VBA)?

Thanks
 
Can you provide more information? How do you expect to "Add" queries? Do all
queries have a common column or columns?
 
The three crosstab queries come from three tables, all with the same
structure. The resulting crosstab queries arrange data by state and product,
like this:
1 2 3 4
CA 100 300 150 200
IL 200 100 100 150
NY 500 400 300 450

The final recordset will add all three crosstab queries together and display
the sum in that same format.
 
If all three tables have the same structure then I would create a union
query to combine them. Then build a crosstab query based on the union query.
 
You haven't provided enough information so I have been making suggestions
that might or might not work. Can you provide the structure of the three
tables as well as the SQL of your crosstabs?
 
Back
Top