SQ語句是﹕ SELECT COUNT(Breakfast) FROM Meal WHERE Breakfast = '有'GROUP BY WorkerCode 但報表中就不知道了﹐報表中怎么實現上面語句的功能?
假设字段名为AAA 表名为 TABLE1 则统计为空记录总和为 SELECT COUNT(*) AS AAA_ISNULL FROM TABLE1 WHERE (AAA IS NULL) 得到的 AAA_ISNULL 就是为空的总和 同样得到不为空的总和 就是 SELECT COUNT(*) AS AAA_NOTISNULL FROM TABLE1 WHERE NOT (AAA IS NULL)
SELECT COUNT(Breakfast) FROM Meal WHERE Breakfast = '有'GROUP BY WorkerCode
但報表中就不知道了﹐報表中怎么實現上面語句的功能?
SELECT COUNT(*) AS AAA_ISNULL FROM TABLE1 WHERE (AAA IS NULL)
得到的 AAA_ISNULL 就是为空的总和
同样得到不为空的总和 就是
SELECT COUNT(*) AS AAA_NOTISNULL FROM TABLE1 WHERE NOT (AAA IS NULL)