Query

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

Guest

Hi:

I have 2 tables that have common structure. Both have 2 colums, (1) Account
Title
(2) Amount.

I want to sum the Amount colums of the 2 tables. How will i do that. Thanks.
 
Create a Union query similar to this below

SELECT Sum(Table1.Amount) AS SumOfAmount FROM Table1;
UNION SELECT Sum(Table2.Amount) AS SumOfAmount FROM Table2;

Create another query based on the Union query above and select the
SumOfAmount column. Click on the totals icon on the toolbar and change Group
By to Sum.
Run the query.
 
Back
Top