Question Creating a vacation and sick day tracker in access

[ale_musicgurl]

Hi

I'm creating a database to track sick and vacation days

I currently have a table of all the employees and their vacation and sick days for 2009 with fields Name, Date, Vacation, Sick, Funeral, Other, Details. I then have a second table which uses a query to look up the day of the week (for statistical purposes) on which their vacation/sick hours fell on.

The problem I'm having now is I need to find a way to
1) input new vacation hours under the fields Vacation, Sick, Funeral, Other details etc to go in my first table (Vacation Summary)
2) have a way to track hours for a year, and rollover left over hours to the next year automatically on december 31. This has to be done for each column in the vacation summary listed above

Please help, I have no idea how to approach this.

 

[AlienRay]

First off, you shouldn't be storing the days off in the Employee list table. You need one table that contains just a list of employees, along with whatever information is needed to calculate how many days off they're entitled to, such as their Start Date and Rank.

Then, you need a second table to store your record of all time off. This field will likely need five fields: an Autonumber ID, the Employee ID, the date of absence, the number of hours taken, and the category of absence.

To enter new days off, you'll simply create a form that allows you to create records against this second table. To calculate time off remaining and year-end carryover, you'll create a query that sums time taken by Employee and by year, then compare that to the entitlement figures that are calculated based on the employee data.

 

[ale_musicgurl]

Thanks a bunch, looks like I'm starting this one from scratch because I really messed it up the first time

Question:
If I follow that form...
What happens when people change rank?