Is any option to NVL in MS-Access

See more:

MS-Access

Hi,

This query is working properly but gives blank value instead i want Null value so i tried NVL but it not worked in MS-ACCESS which function i will use replace blank value & how use in below query.

(SELECT SUM(Review.TotalPrincipalPayments)+ SUM(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], ted During the Period],ed During the Period],