Creating Totals for Union Query?

[Preetham16]

Hi gurus,
How do I create totals for specific columns in a Union Query? Some code would be of Great appreciated

 

[HarleyQuinn]

I would wrap another query round your UNION query, doing it that way you can pretty much do whatever you want with the results.

Hope this helps

HarleyQuinn
---------------------------------
Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[Preetham16]

I am trying to do the same thing .. but could not succeed so far could you please tell me the step how I can do that ..?

 

[HarleyQuinn]

Basically, something like this:

SELECT Field1, Field2, Sum(Field3)
From
(SELECT Field1, Field2, Field3...
UNION
SELECT Field1, Field2, Field3...)
GROUP BY Field1, Field2

You do a select query using the UNION you made as the from criteria.

Hope that helps.

HarleyQuinn
---------------------------------
Get the most out of Tek-Tips, read FAQ222-2244 before posting.