Search results

  1. K

    query for absent employee

    Thank you khawar ! God bless you. your the best.;)
  2. K

    query for absent employee

    Khawar , when I tried to import the attendence excel sheet to MSAccess than I run the query it gave me wrong output (all users names appeared as absent) Could you please check the attachment? (note that all the data in the excel should be import to access) Thanks again:)
  3. K

    query for absent employee

    You are my hero. :DThanks so much for your help. But could you please explain it to me. I want to see the query also how did you do it? or I will not be able to use it.:confused: (BTW Im beginner)
  4. K

    query for absent employee

    Thanks Jal,but I mean I need the exact date when the employee absent For example: Tom was absent on 2-1-2007 , so there is no date in or date out ( these data came from ID card reader machine which is somethime miss one of these recordes date timein or date timeout). datein or dateout mean the...
  5. K

    query for absent employee

    Hi, I have to create report for only absent employee. there are two tables table1(employee id,date in,date out,description) table2(employee id,description) ----------------------------------------- The data in table1 I get it monthly from id card reader for attandence ,but the problem it...
Back
Top Bottom