>Report >Total Table1 Total Table2 Total Table3 >3000 7000 13000 > > >Thank you John, <PRE> SELECT ; SUM(Amount1) AS Amount1, Sum(0) AS Amount2, SUM(0) AS Amount3; FROM Table1 ; UNION SELECT ; SUM(0) AS Amount1, Sum(Amount2) AS Amount2, SUM(0) AS Amount3; FROM Table2 ; UNION SELECT ; SUM(0) AS Amount1, Sum(0) AS Amount2, SUM(Amount3) AS Amount3; FROM Table3 ; INTO CURSOR Amounts SELECT ; SUM(Amount1) AS Amount, Sum(Amount2) AS Amount2, SUM(Amount3) AS Amount3; FROM Amounts ; INTO CURSOR Summary