Payroll Database

[Dan]

Hello everyone, I am in need of your assistance. I am
trying to build a payroll database for a local fire
department. I know what I want it to do, I'm just not
sure how to get it done. My first problem is I can not
figure out how to calculte time. The paid driver works a
24 hour shift, so for example, they start on Monday at
7am and end on Tuesday at 7am. I am looking for the hours
worked to appear on the timesheet form after they enter
the time they work. I also need to keep track of the time
they can take off, personal, sick, vacation. On the time
sheet form they would enter the time they took off and to
what account to charge that time, I then would like the
time to update itself showing the time off, so if you
used 10 hours vacation, it would deduct 10 hours from
your balance. Then I need to generate a report at the end
of the pay period to be turned in to the village for pay.
If anyone can help me out I would really appreciate it.
If any other questions or if you want to reply to me
directly, please e-mail me at (e-mail address removed)

Thanks Dan

 

[Ken Snell]

Dan -

From your post, it sounds as if this is your first effort on building an
ACCESS database. If so, you're in for an interesting, challenging, and
rewarding exercise. I suggest that, if you haven't already, purchase a
fundamental book about ACCESS that will give you some excellent starting
tips and methods.

With respect to calculating time differences, VBA code has a function
(DateDiff) that allows you to calculate the time difference (or date
differences) between two dates and/or times. This is documented in the Help
file in ACCESS. In ACCESS, dates and times are stored together as a floating
point, decimal number. The integer portion are the number of days since
12/31/1899, and the decimal portion is the fraction of time (based on a
24-hour clock) since midnight. Thus, a date and time of January 1, 2003 at 8
PM is this number:
37622.8333333333

With respect to the other questions about tracking vacation, sick, personal,
etc. time, this can be done by thoughtful construction of your tables. In
ACCESS, the table structure is the linchpin upon which efficient, easy
manipulation of your data depends. What table structure have you set up so
far?