MS-Access中的NVL是否有任何选项 [英] Is any option to NVL in MS-Access

问题描述

此查询工作正常，但提供空白值，但我想使用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],

推荐答案

使用Nz函数

MS Access:Nz功能 [

Use Nz function

MS Access: Nz Function[^]

这篇关于MS-Access中的NVL是否有任何选项的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！