A aattas Registered User. Local time , 00:59 Joined Dec 24, 2014 Messages 75 Aug 27, 2021 #1 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?
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, 17:59 Joined Apr 9, 2015 Messages 4,354 Aug 27, 2021 #2 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.
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.
A aattas Registered User. Local time , 00:59 Joined Dec 24, 2014 Messages 75 Aug 28, 2021 #3 Thanks a million pal. It works
