how can I replace blank value with zero in MS-Acess <p>I have below query in Ms-Access but I want to replace Blank value with zero but I can't get proper answer. Is there any way to replace blank value in zero.</p> <pre><code>(SELECT SUM(IIF(Review.TotalPrincipalPayments,0,Review.TotalPrincipalPayments))+ SUM(IIF(Review.TotalInterestPayments,0,Review.TotalInterestPayments )) FROM tblReviewScalars as Review INNER JOIN tblReportVectors AS Report ON(Review.LoanID=Report.LoanID) WHERE Report.AP_Indicator="A" AND Report.CashFlowDate=#6/5/2011# AND Review.AsofDate=#6/5/2011# AND ( Review.CreditRating =ReviewMain.CreditRating)) AS [Cash Collected During the Period], </code></pre>