Me neither (but there were two separate boxes for date and date by month), but I tried working out on these ROwSource's, they do the same thing but different ways but none of them work. Can you figure out why and what can be done to fix them?
SELECT (Format([Date],"MMM 'YY")),Count([Category2]) AS [CountOfCategory2] FROM [UnionT1] GROUP BY (Year([Date])*12 + Month([Date])-1),(Format([Date],"MMM 'YY")); (Count of hours for category2 off by 100 hours)
SELECT Sum([A1 L1] + A1L2 + A1L3 + A1L4 + A1L5 + [A1 Anc] + A1O) AS SumHrs
FROM Table1
GROUP BY Format([Date], "yyyymmm"); (Shows no error but no graph shows up either)
SELECT Sum([A1 L1]), Sum(A1L2), Sum(A1L3), Sum(A1L4), Sum(A1L5), Sum([A1 Anc]), Sum(A1O)
FROM Table1
GROUP BY Format([Date], "yyyymmm");
(Something totally different shows up, pic below)