Recent content by Eemits

I am trying to add table of costs against a project and where no costs exist, report a 0 (zero) instead of null to allow a profit/loss figure to be generated. I have the SQL as: SELECT tblCostings_Expense.Project, Sum(Nz([tblCostings_Expense],0)).[Inv Value] AS Purchases FROM...