First off, I am very new to MS Access and so this may be a trivial question, but I have spent far too long messing around with the SQL without being able to figure it out, so I am hoping someone can help me out.
Basically I need to combine the two following charts into one chart, as two separate series. I can make each of the charts individually just fine,
but I have tried every way of combining them that I can think of without success. I feel like this should be a really simple thing to do that I am just overlooking due to lack of experience. The best I can do is to create a chart with both series on it, but the counts for each month are always the same (i.e. there would just be two columns for every one column in the first graph, with all the same values). Any help with this would be greatly appreciated.
Here are the two charts I am trying to combine and their SQL
Code:
SELECT [Manager Deliv Month].Expr6, Count(*) AS [Count]
FROM [Manager Deliv Month]
GROUP BY [Manager Deliv Month].Expr6;
SELECT [Manager Deliv Month].Expr3, Count(*) AS [Count]
FROM [Manager Deliv Month]
GROUP BY [Manager Deliv Month].Expr3;