Multiple Charts Instead of One (1 Viewer)

Mike Borozdin

New member
Local time
Today, 13:33
Joined
Feb 28, 2009
Messages
1
Hello,

I want to create a simple pie chart, the query is quite simple:

Code:
SELECT Complaints.[Category], Count(Complaints.[Category]) AS CountOfCategory
FROM Complaints
GROUP BY Complaints.[Category];

When I run the query I get number of complaints per category. However in the report several charts are displayed instead of one. Actually, the number of charts is the same as number of the records in Complaints table.

What am I doing wrong?
 

Users who are viewing this thread

Top Bottom