SELECT [PS P&T].Project, [PS P&T].[Working station], IIf([PS P&T]![上岗证发放日] Is Null And [PS P&T]![实习证发放日] Is Not Null,count[PS P&T].Employee id,0)) AS 实习证
FROM [PS P&T]
GROUP BY [PS P&T].Project, [PS P&T].[Working station];作者: todaynew 时间: 2011-2-23 16:14
SELECT Project,[Working station], count(IIf([上岗证发放日] Is Null And [实习证发放日] Is Not Null,[Employee id],0)) AS 实习证
FROM [PS P&T]
GROUP BY Project, [Working station];作者: leel69 时间: 2011-2-24 12:48
谢谢斑竹,你的这个语句也试过,但是没有记录的Workstation还是不返回0值的,