PIEChart problem

[airtabaki]

Hello,

I've got a project where I have to place a lot of identic installations over Belgium, now I have a table where I have stored all this installations:
table: SITES key: SITE ID (here in I have also stored from when an installation was fully operational)
Now I have another table with all the Defects which is coupled with this SITES table:
table: DEFECTS key: SITE ID & DEFECT ID (here in I have also stored from when to when an installation was defect)

What I want to do is to make one chart for each site in which I can see how many time (percentage!) an installation
worked perfectly and how many time there were defects and which.

for instance:
SITE001: is activated 100 days before
had 2 defects:
defect 1 lasts 5 days
defect 2 lasts 1 of 10 days

--> I want to show a pie chart in which shows the following:
85 % of the time the installation worked perfectly
5 % of the time the installation showed defect 1
10 % of the time the installation showed defect 2

The problem is that my table shows only the defects. It doesn't show when the installation works perfectly.
So it will show:
33 % defect 1
66 % defect 2

Can anyone help me with this

 

[dhookom]

I don't see anything in your tables/fields that would provide the "100 days". How is a graph supposed to know about it?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]