SELECT 工序, 姓名,月份, 规格型号, (Case When 工序= '干压生产线抛光' Then Sum(正品数) Else Sum(生产数) End) AS 生产数,工价,Sum(工资) AS 工资 FROM {日报表} GROUP BY 工序, 姓名,月份,规格型号,工价 HAVING ((Not ({日报表}.姓名) Is Null));
但是我想多选择条件就不能运行,具体是什么原因:
SELECT 工序, 姓名,月份, 规格型号, (Case When 工序='干压生产线抛光' or '干压生产线装坯' Then Sum(正品数) Else Sum(生产数) End) AS 生产数,工价,Sum(工资) AS 工资 FROM {日报表} GROUP BY 工序, 姓名,月份,规格型号,工价 HAVING ((Not ({日报表}.姓名) Is Null));