Hi All
I am new to the site and appreciate your help. I have had expereince with acccess for many years but all lost since did not use them.
I need to create a simple database to keep track of employees attendance. And i need your help.

Database may contain the followings:
EmpID
EmpName
Date
TimeIN
TimeOut
HoursWorked
Abscent(y/n)


any help will be appreciated:cool:

Employee table with EmpID, EmpName

A related table:
Attendence with EmpID, Date, TimeIN, TimeOut

HoursWorked is a calculated value and thus not stored.

Absent is a derived value and should not be stored. It would be indicated by no TimeIN value.
Otherwise it would be possilble to have a conflict with the employee indicated as absent but having a TimeIn value making it a breach of normalization.

I assume you meant "Absent" unless you are referring to the smell of their abdominal region.:D

:DThanks
Hours worked is not essential, just want to know who is in and not in.
Basically keep track of thier "smell lol" joke aside , just to track of number of days working, leave with no pay, holidays, etc.

Nothing fancy, just functional.

Thanks again