var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: finding missing entries
Hello all and thanks in advance!!!!!
I have a table that hold production information that is entered by mechanics on the floor. They are SUPPOSED to enter this data daily by shift.
What I am attempting to do is create a query that loops through the table and looks for a missing shift.
I need to check each day for 1st, 2nd, and 3rd shift for each machine. I only want to return the shift and machine number that has missed entering data.