[求助]查询计数问题

穷鬼书生

给看一下这句是那儿错了，我想在信用等级是空时不参加计数
Count(IIf([信用等级] Is Null,0,[信用等级]),"数据库") AS 已核定户数

青青

DCount?

穷鬼书生

例子中的“前莲村”怎么查询后“已核定户数”还是2啊，我想在“信用等级”没有的就不统计了，应该是“0”才对啊

tagxs

有大侠在吗？

我也需要这方面的内容

就是：字段为空或为0时不参加计数

wwwwa

SELECT [数据库].[家庭住址], Count(DLookUp("[姓名]","数据库")) AS 总户数, Sum([数据库].[核定总额]) AS 总金额,
sum(iif([数据库].[信用等级]>0,1,0)) AS 已核定户数, Sum(IIf([信用等级] Is Null,0,[核定总额])) AS 已核定总额, Format([已核定户数]/[总户数],"ercent") AS 已核定占比, Sum(IIf([信用等级]=3,1,0)) AS A类户数, Sum(IIf([信用等级]=3,[核定总额],0)) AS A类已核定总额, Format([A类户数]/[已核定户数],"ercent") AS A类占评定户数, Sum(IIf([信用等级]=2,1,0)) AS AA类户数, Sum(IIf([信用等级]=2,[核定总额],0)) AS AA类已核定总额, Format([AA类户数]/[已核定户数],"ercent") AS AA类占评定户数, Sum(IIf([信用等级]=1,1,0)) AS AAA类户数, Sum(IIf([信用等级]=1,[核定总额],0)) AS AAA类已核定总额, Format([AAA类户数]/[已核定户数],"Percent") AS AAA类占评定户数
FROM 数据库
GROUP BY [数据库].[家庭住址];