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.

tblProdInfo
rowID int
entrydate datetime
MachineNum int
Shift int
ProData int

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.

Thanks again,
Lee