Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Posts
    2

    Unanswered: report in access

    I have text file of attendance logs which I have imported into access.

    The file contains the following punching data
    name.surname 1/12/2003 8:00
    name.surname 2/12/2003 8:01
    so forth for all the names at all present dates.

    I have imported this into access table which has three fields
    name, date, time

    I need a report which will give me a sum of days absent in the following format

    name.surname [late 10to15 minutes] 3 days
    name.surnamce [late 16to20 minutes] 2 days
    name.surname [total days punched] 24 days

    2ndname.sur [late 10to15 minutes] 2 days
    2ndname.sur [late 16to20 minutes] 8 days
    name.surname [total days punched] 23 days
    so forth

    how can I write a report for this...I have tried a lot of places to get help

    Regards,

    Edward

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Ed,

    How do you determine whether someone is late? Calc'ing the # of days is simple ... Once you specify what late is then you can use DateDiff to give you the difference and from there determine what "lateness" bucket the tardiness goes in.

  3. #3
    Join Date
    Dec 2003
    Posts
    2
    Owen,

    we have different deduction rates for different late timings so if a person is say in the month of december late as follows
    10to15 16to20 21to25 26to30 above30 above60
    name1 2 3 1 0 0 1
    name2 4 0 0 0 0 0

    so the deduction is a day's salary for 3 days above60. If 10to15 minutes late and if no other late days in other columns maybe just warn and ignore.

    I hope I have answered your question correctly.

    Thanks,

    Edward

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •