Employee Absense/Holidays Database

[M8KWR]

Hi all,

I am stuck where to start and wanted some advise. I want to create a database that captures whether employees are late, sick, holidays etc.

So i would have a list of employees, then create a new records in another table to store what type of reason it is, (late, sick, holidays etc.), and then the directors can monitor employee sickness. But what i would to do is to be a bit clever about it though in 2 ways.

Against the employee they would have a number of allocated holidays against them, but i just wanted the user to enter the start and end date, and then get access to work out how many holidays days need to be taken off, i.e. it does not included weekends or bank holidays....

Also in the sickness report, work out how many single days where taken on either a Monday or Friday....

Has anyone done or seen an access database that can do this already.

I know there is a calendar addin, but i've not used it...

 

[cdoyle]

Sounds like you're trying to do almost what I'm trying to do.

http://www.access-programmers.co.uk/forums/showthread.php?t=91295&highlight=Calendar

I got the calendar part to work (I used the example shown in the link on the first post) but now I need to get a DAP of the calendar to display on our Intranet. That's where I'm stuck, I can't seem to get it.

But if you don't need to have it as a webpage, take a look at that link in the first post. I think that's what you're looking for.

Chris.

 

[ejstefl]

This should be a pretty standard database. You're on the right track, you'll need a table for your employee information, a table for your reasons, and a table for dates taken off or came in late.

Working out if a date is a Monday or a Friday can be done using the DatePart function.

Working out the numebr of working days can be done using the function listed here: http://www.mvps.org/access/datetime/date0006.htm. Note that this will require a table called tblHolidays where you will enter all bank holidays.

 

[The_Doc_Man]

Search this forum for keyword HOLIDAY (or HOLIDAYS) because this topic has come up many times before.