我正在尝试输出包装尺寸图。这是一张图表,告诉您有多少项目花费在2个数量之间。
例如:
Project Spend
1000
1500
35000
36500
40000
55000
89000
105000
110000
140000
包装尺寸图会生成条形图。在这种情况下,数据将是。
Between £0-£50000 £50000-£100000 £100000+
Number of Projects in Band 5 2 3
如何使用查询获取MS Access 2007以生成所需的条形图?
你应该使用条件的聚集,在您使用iif()
具有sum()
:
select "Number of Projects in band" as which,
sum(iif(ProjectSpend between 0 and 49999, 1, 0)) as band1,
sum(iif(ProjectSpend between 50000 and 99999, 1, 0)) as band2,
sum(iif(ProjectSpend >= 100000, 1, 0)) as band3
from yourtable as t;
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句