Access DB Help

[sao123]

I have a simply table consisting of 5 columns. (1 primary key, 1 data field,
and 3 lookup fields) Primary Key, Location, Material Used, Problem, Problem
Severity

In my database, an entry is a problem if the amount of material used is above a
certain threshold value. i have created a query which makes a count of each
problem occurance. then I have made a report, which is grouped on
region, lists each problem type and the count of times that problem has
occured.

i have 3 locations: greensburg, youngwood, and latrobe.
I have 4 problems: contoller malfunction, user error, material defect, other

My report looks something like this:

Region: Greensburg
Problem: Controller Malfunction 1 times
Problem: User Error 2 times

Region: Youngwood
Problem: User Error 3 times

Region: Latrobe
Problem: Material Defect 1 time.


The region line is a header and the problem info is in the details.
I want to be able to place a pie chart in the region footer for each
section, which will display the same information as printed. The report
lists all the data correctly, However the series of pie charts refuse to work
on grouping.

I get lots of blank charts. Can someone guide me into how to create a
repeating pie chart which will repeat in a section footer for every region I
have?

 

[sao123]

i tried the examt same steps in access 2003 and surprisingly it worked... apparently there is soemthing wrong with the chartwizard in 07.

close this thread.