To use SUM, do you not have to use a GROUP BY ? >>> SUM(Cost),SUM(OBV),SUM(SalePrice),Sum(DeprRec),Sum(capgain) from reportData Best Regards, Gunnar Swan http://www.PracticeToPass.Com Software Built For Statutory Courses