Hi Guys
I have a database which updates on a daily basis the production figures and scrap figures on several machines running lots of different tooling . The machines are constantly changing tooling .Currently I have lots of queries which can analyse the figures and look at the production figures and scrap rates on tools and machines etc.. But I have a problem which I'm not sure how to over come. I would like to make a report that can show me the how each piece of tooling ran on each production run by working on the figures between the dates it ran. So it can show me Tool "A" ran in machine "1" between date "A" and date "B" and the scrap rate was "X"
I cant identify when the production run finishes. The longest a tool would not run would be two days(weekend) Any ideas would be much appreciated