Solved Add (sum) two results from two different tables (1 Viewer)

aattas

Registered User.
Local time
Today, 16:12
Joined
Dec 24, 2014
Messages
74
I have two reports from two different tables with results of sum of numbers of each and i need to add them together .

Any suggestion?
 

Ranman256

Well-known member
Local time
Today, 09:12
Joined
Apr 9, 2015
Messages
4,339
you could take the queries from each rpt into a 3rd qry, join them , then do the math.
or
put each qry into a 3rd qry UNION query, then do the sum.
 

aattas

Registered User.
Local time
Today, 16:12
Joined
Dec 24, 2014
Messages
74
Thanks a million pal.
It works
 

Users who are viewing this thread

Top Bottom