关于多个月份日期的快速 SQL 问题

Question

SELECT DISTINCT MonthName(Month([Date])) AS [Month], tblSupportCalls.System, Count(tblSupportCalls.System) AS [Total for System], Year([Date]) AS [Year]
FROM tblSupportCalls
WHERE (((tblSupportCalls.Date) Between Now() And Now()-7) AND ((tblSupportCalls.System) In ('Career Campus','E-PEEP')) AND ((tblSupportCalls.StartTime) Is Not Null) AND ((Hour([StartTime]))>=7))
GROUP BY tblSupportCalls.System, tblSupportCalls.Date;

每当我输入它时，它都会给我多个月份，例如：

July
July
July

我只想说七月一次，我不明白为什么每个字段都会在不同的日子重复。我只想说：

月|系统|整体系统| 年份

我所看到的

> MONTH | System | Total Systems | Year
> July      CC           2         2010
> July      CC           7         2010
> July      CC           9         2010
> July      EE           1         2010
> July      EE           2         2010

需要是：

MONTH | System | Total Systems | Year
July      CC          18         2010
July      EE          03         2010

Answer 1

您希望按年份和月份而不是 tblSupportCalls.Date 进行分组。

...
GROUP BY tblSupportCalls.System, Year([Date]), Month([Date]);

Answer 2

不过，您仍然按日期对结果进行分组（而不是按月份）。我认为您想要的是这样的：

GROUP BY tblSupportCalls.System, Year ([tblSupportCalls.Date]), [Month([tblSupportCalls.Date]);

我想您仍然想按年份分组，以便 2010 年 7 月与 2011 年 7 月显示在不同的行中。