Showing time that Isn't there.
Posted on 2008-09-30
Ok i'll try to explain this and not leave out too many details. If I do please ask and I'll provide them. I'm sure there is a easy solution to this i just cant figure it out right now...here goes: In table A i have an ID (key) that matches an ID in table B. For any given week students check in and out of table B, this creates a record in table B that looks something like:
ID | StudentName | TimeIn | TimeOut
Ifi want to query table B for TimeIn and TimeOuts for all students that match a student in table A then,..no big deal:
ID, TimeIn, TimeOut
Table A AS a
Table B AS b ON a.ID = b.ID
TimeIn >= A_dateTime
Now, here is the problem, how do I show the students that did not have time. In other words I want to show all the students and for those that did not have time display a message like:
"NO TIME" or something along those lines. And yes this is pretty much a "punch clock" or a payroll type of thing. The thing is that in some cases I do get the "NO TIME" students to show up, but not all the time so I'm not getting all of the students to show up...