Argg...won't chart what I want.

[commanderrico]

Ok, I have a database that tracks the downtime for machines in my turning shop. Each Line has specific Machines on it which vary from line to line. In the table, each machine has details about when it was down, why, how they fixed it, and how long it took. What I want to do in form is have the user input two dates and the program will find all the recorded instances of downtime between those two dates. I have the report organized by Shift, then Line. For every line I want to make a pie chart that shows the downtime for each machine on that line. Then after the next lines recordes it will show the downtime for that lines machines, etc. What it's doing is when I make the chart from my query its putting all the machines for all the lines on the same chart and just repeating it after each line. I've been working on this for two days now and I can't seem to get it to do what I want. Does anyone have any suggestions? Thanks so much in advance! If anyone has any more questions, just ask, hell I ask enough questions.

Rico

 

[dhookom]

You can use the Link Master/Child properties of the graph control to limit the pie to the current Line. You may find the graph display data may not be in-sync with your report section. This might require code in the On Print event of the section containing the Pie:
Dim obj as Object
Set obj = Me.GrpMyPie 'your control name
obj.Refresh
obj.Requery
Set obj = nothing


Duane
MS Access MVP