Scope - Capture down time by machine
We have production machine producing parts over a shift
Within this time there will be down time.
The operator records the down time and production data within a database.
The structure is basicly
Date
Shift
Machine
No of Good Parts Made
No of Bad
DT1 (dropdown box list of known issues)
DT1 Time (time lost due to above)
DT2
DT2 Time
DT3
DT3 Time
ETC..........
Collecting the data not a problem however we have around 25 codes for 25 differant downtime catagorys. Completing a Query to list Total Down Time per Catagory seems impossible espacially as the operators may but to DT catagory in DT1,DT2,DT3.............. Cell
There must be a easier way. I tried Two tables, one for production & one for down time but still struggled
We have production machine producing parts over a shift
Within this time there will be down time.
The operator records the down time and production data within a database.
The structure is basicly
Date
Shift
Machine
No of Good Parts Made
No of Bad
DT1 (dropdown box list of known issues)
DT1 Time (time lost due to above)
DT2
DT2 Time
DT3
DT3 Time
ETC..........
Collecting the data not a problem however we have around 25 codes for 25 differant downtime catagorys. Completing a Query to list Total Down Time per Catagory seems impossible espacially as the operators may but to DT catagory in DT1,DT2,DT3.............. Cell
There must be a easier way. I tried Two tables, one for production & one for down time but still struggled