Trying to create report with pie chart for a three record count query 1

[RobertIngles]

Sorry about this, should be very simple but my mind is mush.

I have a query that retuns the the summary count of three categories located in a column of TBL_A. So when I run the query it returns:

Catgory Count
[Category1] TtlCountofCategory1
[Category2] TtlCountofCategory2
[Category3] TtlCountofCategory3

I want a report that shows the data and includes a pie chart representation of the data. Every time I create the report I get the three data sets and three charts all showing the category as 100% of the chart.

How do I get the three data sets (fields) and a single pie chart showing the distribution for each category?

Thanks
Robert

 

[dhookom]

The Pie Chart should be in either the Report Header or Footer section. Make sure the Link Master/Child properties are blank.


Duane
Hook'D on Access
MS Access MVP