Hello folks
I am creating a database for use at work which can look at production figures and scrap figures in lots of different ways .The tables are populated daily. I currently have queries which look at machine scrap rates by date and scrap by machine ,production figures ect ect.
At the moment it can return production figures and scrap % by day and I have a query that can get the average % of scrap by machine .
Is there a way of making a query that will work out the % of scrap from the total parts made by machine instead of the average scrap %.
I hope that make sense .
Loving the site and learning a lot from it
Bookmarks