Home Forums Programming General sql query need Help about Absent Employee RE: sql query need Help about Absent Employee

  • June 14, 2008 at 9:18 pm

    #828942

    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...