在平时写查询时，我们会写类似下面的查询语句：

Select Department, ProductionDate, Process, LotNumber, 
Sum(ScrapQty) AS ScrapQtyOfSum, "早班" AS a
FROM tbl_ProductionData 
GROUP BY Department, ProductionDate, Process, LotNumber, "早班"

当我们放在Access里运行时不会出错，但是当后台改成SQL Server时就会出现以下问题：

解决方法：

Select Department, ProductionDate, Pro,cess, LotNumber,
 Sum(ScrapQty) AS ScrapQtyOfSum "早班" AS a
FROM tbl_ProductionData
GROUP BY Department, ProductionDate, Process, LotNumber