I wish to create a chart, histogram, that shows the number of occurances in
each month of three unrelated events for which I have the dates. I've tried:
Group by - Date By Month: Format$(Date1,'mmmm yyyy')
Count - DateA: Date1
Count - DateB: Date2
Count - DateC: Date3
The SQL comes out as:
SELECT DISTINCTROW Format$(Client.DateOfReferral,'mmmm yyyy') AS [Date By
Month], Count(Date1) AS DateA, Count(Date2) AS DateB, Count(Date3) AS DateC
FROM Fred
GROUP BY Format$(Date1,'mmmm yyyy');
But the result is incorrect. How can I make the "Group by" be independent of
any of the data? Thanks.
|