联合查询增加了日期条件后小计不正确？

代码如下增加了“HAVING (((表1.日期)=[请输入年月日]))”这段日期条件：

SELECT Left([代码],1) & "类小计：" AS 分类代码,'' as 部门, Sum(表1.a1) AS a1之总计, Sum(表1.a2) AS a2之总计, Sum(表1.a3)+Sum(表1.a4) AS b1之总计, Sum(表1.a5) AS a5之总计, [a1之总计]+[a2之总计]+[b1之总计]+[a5之总计] AS 小计
FROM 表1
GROUP BY Left([代码],1) & "类小计："

UNION ALL

SELECT 表1.代码,表1.部门, Sum(表1.a1) AS a1之总计, Sum(表1.a2) AS a2之总计, Sum(表1.a3)+Sum(表1.a4) AS b1之总计, Sum(表1.a5) AS a5之总计,[a1之总计]+[a2之总计]+[b1之总计]+[a5之总计] AS 小计
FROM 表1
GROUP BY 表1.代码,表1.部门,表1.日期

HAVING (((表1.日期)=[请输入年月日]))

UNION ALL SELECT "合计：" AS 表达式1,'' as 部门,Sum(表1.a1) AS a1之总计, Sum(表1.a2) AS a2之总计, Sum(表1.a3)+Sum(表1.a4) AS b1之总计, Sum(表1.a5) AS a5之总计,[a1之总计]+[a2之总计]+[b1之总计]+[a5之总计] AS 小计
FROM 表1
ORDER BY 分类代码;

输入日期2009-01-01查询后图片如下：日期条件对“小计”没有起作用统计的是全部数据的和，“合计”则是正确的。

点击下载此附件