We run a database that keeps track of student's services (activity) in our school district. When a student receives services from 2 people at the same time, same date, the first person is expected to enter minutes for the student. The second person is expected to enter zero for the minutes. Sometimes, the first person forgets to enter minutes and so the only record we have is the second person's record with 0 minutes. We want to find all those instances so we can have that corrected by the staff.

This would NOT be OKStuActID___StudentID___StudentName___ActivityDesc____ActivityDate____MinutesMiles___StaffName12__________843223_______Bobby_______Personal Care____3/1/2013 0:00______0__________Dougie Fresh17__________832113_______John________Personal Care____3/1/2013 0:00______0__________Happy Gilmore

We'd want the query to return all of the "NOT OK" records because they have zero minutes and don't have a matching activity with minutes on the same date. One thing working in our favor is the ActivityDate field does NOT have time stamps. The staff member types in the date so it ends up just the date stamp with zeros for the hours and minutes, so it should be easier to compare the dates.