本文介绍了MS-Access中的NVL是否有任何选项的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
此查询工作正常，但提供空白值，但我想使用Null值，所以我尝试了NVL，但在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],推荐答案
这篇关于MS-Access中的NVL是否有任何选项的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！