本文介绍了添加仅可提升的士兵=计数(IIf [x] =" y"和[z] =" a")的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我需要做类似的事情
=计数(IIf([Rank] =" SPC"和[Promotable] = - 1)
我还需要做
=计数(IIf([Rank] =" SPC"和[WLC] = - 1)
可推广是一个复选框
排名是从下拉框中精确选择的。
我假设-1 =选中该复选框。我是访问报告的新手谢谢
I need to do something like
=Count(IIf([Rank]="SPC" and [Promotable]=-1 )
I also need to do
=Count(IIf([Rank]="SPC" and [WLC]=-1 )
Promotable is a Check box
Rank is an exact selection from a drop down box.
I''m assuming that -1 = the box is checked. Im new to reports in access Thanks
推荐答案
展开 | 选择 | Wrap | 行号
这篇关于添加仅可提升的士兵=计数(IIf [x] =" y"和[z] =" a")的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!