添加仅可提升的士兵=计数（IIf [x] =" y"和[z] =" a"） [英] Add Soldiers who are promotable only =Count (IIf[x]="y" and [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

推荐答案

卢卡斯，


你想要嵌套查询有多乱？我'建议使用两个查询，只是为了简化生活。第一个是：

Lucas,

How messy do you want your nested queries to be? I''d suggest using two queries, just to make life simple. The first would be:

展开 | 选择 | Wrap <跨越式s =codeDivider> | 行号

我需要它才能显示在报告中我使用未绑定的文本框来执行此操作。我仍然可以用上面的方法做到这一点，我将如何插入它？我已经制作了一份隐藏所有士兵信息的报告，并且是一页显示我想要的所有统计数据，例如每个士兵等级的计数使用：= Count（IIf（[Rank] =" PV1"，0））ext

I need it to display in a report i was using unbound text boxes to do this. Can i still do this with the method above and how would i insert it? I have made a report that hides all the soldiers information and is one page that displays all the stats i want like the count of each rank of soldiers using :=Count(IIf([Rank]="PV1",0)) ext

我应该指定它是一个报告

I should have specified it was for an report

这篇关于添加仅可提升的士兵=计数（IIf [x] =&quot; y&quot;和[z] =&quot; a&quot;）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！