I'm trying to figure out how to get all employee names, that don't have a record in tblAttendance, for a specific period?

I can't think of a way to say, where data not found, or where entry not found?

I'm guessing i'll have to do a Union to get all employee names. Then maybe do a count, or something. Combine the two and if the employee name has 0 for the count, they had perfect attendace?

Can I get a few pointers in the correct direction, I'd like to play and see if I can figure it out. I'll post once I give up on trying to see if someone has an answer.

Please don't just post the solution yet. =)