Chart

S

Sasha

I'm attempting to create a report that will have a pie
chart for each department. The following creates my
chart, but how can I get it to run for each department?

SELECT [Job],Sum([#Hours]) AS [SumOf#Hours] FROM [Data]
GROUP BY [Job];
 
Top