Question

ACCESS 同一个字段中的不同数值同时统计

如字段1中分别有A B C D E
如何统计成以下表格样式
字段1总计 A合计 B合计 C合计 D合计 E合计
10 5 1 1 1 2

Answer 1

select count(*) as 字段1总计,
sum(iif(字段1='A', 1, 0) as A合计,
sum(iif(字段1='B', 1, 0) as B合计,

sum(iif(字段1='C', 1, 0) as C合计,

sum(iif(字段1='D', 1, 0) as D合计,

sum(iif(字段1='E', 1, 0) as E合计

from 表