Help tracking vacation, sick hours

[rlacyusa]

I need to be able to track employee's vacation, sick hours.

Each employee is given 3.08 hours per pay period (2 weeks) for vacation and sick time.

As each pay period passes it would add 3.08 hours to that employee's total hours accured. Then when an employee uses vacation or sick time it would subtract that amount from the total.

Thanks in advance for any help on this as I am new to Access.
(Access 2002)

 

[ColinEssex]

What have you got so far?

Col

 

[rlacyusa]

I only have the table created with the employee's number, FirsNtname, LastName, vac, sick, per, usedvac, usedsick, usedper, Ahoursvac, Ahourssick, Ahoursper. (Ahoursxxx represent Avaiable hours)

I have created queries to track mileage and time, but not sure on how to keep track of a running total (year to date) for this one?

RL

 

[ColinEssex]

so its just the one table with everything in it?

Col

 

[rlacyusa]

Yes just the one table

 

[skillkeeper]

Hello:

The query component may be relatively simple if no other considerations are in order such as:
Does an employee accumulate time (3.08 hrs) while sick or on vacation?
Does an employee earn time when your business is closed for events such as Easter etc. even if being paid for such a day?

 

[bonekrusher]

In MS Access Help, do a search for Sick time. MS has a great template which tracks employee.