Group by month for a chart
Posted on 2005-02-24
I need to make a chart with many series, so will need data that look like this:
EndDate ServiceA ServiceB ServiceC ......etc.
Nov04 3 6 5
Dec04 4 8 7
Jan05 6 12 2
from a single table that looks like this:
So the integers in the query are the counts per month that a Service appears
I can do this for one service (ie a two -column query, but not all of them in one go- it's the sort of thing that could be done in MS Access with a cross tab query.