[已解决]求查询语句分组求和？不知搞什么搞

jsf2008

老大，我也试过了，请你帮我修改下？
SELECT nka.品名, Sum(nka.生产数) AS 生产数之总计, Sum(nka.出货数) AS 出货数之总计, Sum(nka.投入工时) AS 投入工时之总计
FROM nka
GROUP BY nka.品名
HAVING (((nka.品名) Between [请输入开始日期] And [请输入结束日期]));
上传例子请看

jsf2008

老大，我根据你的也不行，我这换为HAVING条件 WHERE (((nka.日期) Between [请输入开始日期] And [请输入结束日期]))就ＯＫ了
谢谢你老大