Punch card System

[PietKruger]

I am trying to create a "punch card" system in access. Does anybody have an Example or sample that i can use?
Your help would be appreciated.

 

[jsv2002]

How do you intend to gather the information from the "punched cards" will it be automated or someone manually entering the data from them? Is it for a time clock system i.e. Time in/Time Out and calculate hours worked?

Little more information may eneable someone to help

 

[PietKruger]

Thank you for your reply. It will be for a time clock system. Time in / Lunch out / Lunch in / Time out. I want to create a report that could be used as a payslip.

i have 2 tables:

TABLE 1
Id
EmployeeCode
Date
TimeStatus
and

EMPLOYEE TABLE
Id
EmployeeCode
EmpName
EmpSurname
HourlyRate

please help. am i on the right track?

 

[jsv2002]

Your on the right track you will need a table to enter times on/off linked to each employee but to be honest depending on your level of experiance this can be harder than it appears.....

Things such as rounding up or down times, are penalties incurred for clocking in late or out early? Also if shift work crossing midnight and making sure you calculate hours worked correctly.

I haven't gone into this in much detail and pretty sure there will be others with far more experiance to advise you on these pitfalls sounds like an interesting project good luck

John