Summing up totals in Two seperate tables

[Perry Rojas Jr]

Hello,

Could anyone help me, i want to sum up the totals from two different table
to get the overall total in my form and report. Ex

Table 1 Table 2

123 111
111 111
=== ======
234 222 total = 456 (how could i get this total in my form
and report)




thanks,


perry

 

[boblarson]

That would be a UNION Query and then nesting that inside of an aggregate query.
--
Bob Larson
Access World Forums Administrator

Tutorials at http://www.btabdevelopment.com

__________________________________