按ID计算Null记录 [英] Count records by ID that are Null

问题描述

我想弄清楚每年每个奖项还有多少奖金，所以我可以说你已经分三期付款了。


数据如下所示：

PayoutID PayoutDate PayoutUnits CheckRequestDate AwardID

1111 2/7/2014 5 2/6/2014 1234

1112 2/7/2015 5 1234

1113 2/7/2016 5 1234


我正在尝试使用DCount来支付剩余的支出数量。 （当CheckRequestDate为空时）..当我尝试

I am trying to figure out how many payouts remain for each award per year, so I can say "you have been paid out 1 out of 3 installments."

The data will look like this:
PayoutID PayoutDate PayoutUnits CheckRequestDate AwardID
1111 2/7/2014 5 2/6/2014 1234
1112 2/7/2015 5 1234
1113 2/7/2016 5 1234

I am trying to use DCount for the number of payouts remaining. (when CheckRequestDate IS Null) .. When I try

展开 | 选择 | Wrap | 行号

推荐答案

SQL中的DCount没有它与上面代码块中的DCount相匹配。

The DCount in your SQL doesn''t match the DCount in the code block above it.

抱歉！我不小心尝试了别的东西而没有意识到这一点。它已更新。

Sorry! I had accidentally tried something else and did not realize it. It is updated.

但您将其更新为Is Not NULL。我以为你试图计算所有空的记录？

But you updated it to "Is Not NULL". I thought you were trying to count all the records that are null?

这篇关于按ID计算Null记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！