Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
oliver8615
Starting Member
1 Post |
 Posted - 2008-07-05 : 23:24:47
|
| good Day... i need help about my project in school about employee attendance module. I have a table tblEmployee(EmpId,Name,Dept,Position) and another table tblAttendance(EmpId,date,AmIn,AmOut,PmIn,PmOut)I need a query that will find those employees who are absent or those employee who does not have an attendance on a specific date... urgent please thanks a lot.... I am using MS VB 6.0 so far i did was to search those employee's who have not take an attendance for a day.. my query for that is...Select EmpId from tblEmployee not IN (select EmpId from tblAttendance where [date] =#06/06/2008#)my problem for that is i want to know those employee's who have take a consecutive absences using two dates... Filter those employee's who have taken consecutive absences and from what date it is... |
|
|
|
|
|
Need Query for Absent Employee!!!!!!