Query pulling records to gather down time tracking and efficiencies

[mmart33]

Hello all,



I am decent when it comes to writing code and am pretty good at following suggestions once I get pointed in the right direction, so here it goes.

I have an access program that I input daily production records for a packaging plant. I input it in a form and it populates a table (with an enormous amount of fields and information). One of the things i enter in is when there is downtime on a production line and what the problem was ("Downtime Issues Notes") and how long (in hours) was it down for. There are 4 operating lines and most run at 10 hours a day. Some days they do not and I have a "partial day" selection and I input the actual hours the line ran. Each entry is line specific and order specific. Meaning, one production line may run 1-3 products in a day and each product gets an entry. Also when a line has a changeover from one product to the next, I select from a list the type of changeover and it will reference a table that tells how long the line is predicted to be down.

Here is what I need done.
I would like to eventually create a report based off a query that generates the total units produced in a week by each line. And from there, take the total hours ran (most likely 40, but dependant on full days ran) and calculate the pods per hour average that takes into account the changeover selection between records to give us the efficiency. I then want to have another column that determines the total hours of downtime. I would also like each operating Line to show all of its weeks Downtime Issues Notes somewhere close to this specific line data.

Is this too complicated or am I just overwhelmed?

Thanks for the help and I will probably followup with more questions, just need a good push in the right direction.

[mmart33]

Anyone have any ideas?

Thanks

[mmart33]

To give everyone an update. I created multiple queries (5 with joins and relationships from other tables) to get this done and I finally have it. It is too difficult to truly put it on this forum, but I will gladly help someone if need be.


Thanks to anyone that tried to help.