By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,501 Members | 2,768 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,501 IT Pros & Developers. It's quick & easy.

Attendance Database - Help with PTO Time

P: n/a
My employer has asked me to create a database that will keep track of
the employee attendance. Time off / Time earned, excused / unexcused,
etc.

At my company from the 6th month of employment to the second year you
earn 8 hours of PTO each month, from the 2nd to 4th year you earn 10
hours PTO each month.

My question is how would I preform a check for each employee once a
month to automatically add their newly earned PTO time?

Something like - If today's date - employee A start date 7 months
add 8 PTO hours etc.

I know I probably confused everyone reading this, but any help is
greatly appreciated.

Jan 13 '08 #1
Share this Question
Share on Google+
3 Replies


P: n/a
On Sat, 12 Jan 2008 17:44:31 -0800 (PST), lucky33
<ki*******@bellsouth.netwrote:

You could each day when the app starts up see if there are any new
records to be added.
I would probably rather write a VBA function that given the hire date
returns the number of PTO hours accrued.

-Tom.

>My employer has asked me to create a database that will keep track of
the employee attendance. Time off / Time earned, excused / unexcused,
etc.

At my company from the 6th month of employment to the second year you
earn 8 hours of PTO each month, from the 2nd to 4th year you earn 10
hours PTO each month.

My question is how would I preform a check for each employee once a
month to automatically add their newly earned PTO time?

Something like - If today's date - employee A start date 7 months
add 8 PTO hours etc.

I know I probably confused everyone reading this, but any help is
greatly appreciated.
Jan 13 '08 #2

P: n/a
On Sat, 12 Jan 2008 19:12:03 -0700, Tom van Stiphout wrote:
On Sat, 12 Jan 2008 17:44:31 -0800 (PST), lucky33
<ki*******@bellsouth.netwrote:

You could each day when the app starts up see if there are any new
records to be added.
I would probably rather write a VBA function that given the hire date
returns the number of PTO hours accrued.

-Tom.

>>My employer has asked me to create a database that will keep track of
the employee attendance. Time off / Time earned, excused / unexcused,
etc.

At my company from the 6th month of employment to the second year you
earn 8 hours of PTO each month, from the 2nd to 4th year you earn 10
hours PTO each month.

My question is how would I preform a check for each employee once a
month to automatically add their newly earned PTO time?

Something like - If today's date - employee A start date 7 months add
8 PTO hours etc.

I know I probably confused everyone reading this, but any help is
greatly appreciated.
I've got an even tougher problem for you. At my place of employment, as
a supervisor, I've used an ACCESS database I constructed to maintain my
employees time and attendance in such a way as to give me each of their
leave balances and tenure for any given day I enter into a dialog box
(form). There is an input form for entering each employee's annual, sick
and holiday leave taken, and also leave and tenure accrued. Where I
work, an employee who has between 0-5 years tenure earns 5 hours annual
leave each semi-monthly pay period; between 6-10 years, 6 hours; between
10-15 years 7 hours and for 15 years and up, 8 hours. And, every
employee earns 6 hours sick leave each pay period regardless of tenure.
Because there is a payday twice a month, this means leave accrues on
payday, which means some months it accrues on the 16th of the month and
others the 15th. I've never taken the time to automate this in my
database, so I have to enter leave and tenure accruals manually for each
employee every payday. I believe there should be a simple way to have
the database check the date on startup (use the VBA Date() function
perhaps) and have the Time_and_Attendance table update leave accruals and
tenure earned for each employee each month, perhaps through an Update
Query that executes via a macro triggered by the main form load event.
Does anyone have any experience in this area that can lend some advice as
to how this can be done?
Jan 13 '08 #3

P: n/a
On Sun, 13 Jan 2008 02:35:10 GMT, Don Calloway
<dr********@verizon.netwrote:

There is no simple answer for your scenario; it would require some
analysis time to really think this through. I wrote such an
application once for a large company. Many business rules - including
different penalties for different kinds of absence. "Hire a competent
developer" is the best advice I can give.

-Tom.

>On Sat, 12 Jan 2008 19:12:03 -0700, Tom van Stiphout wrote:
>On Sat, 12 Jan 2008 17:44:31 -0800 (PST), lucky33
<ki*******@bellsouth.netwrote:

You could each day when the app starts up see if there are any new
records to be added.
I would probably rather write a VBA function that given the hire date
returns the number of PTO hours accrued.

-Tom.

>>>My employer has asked me to create a database that will keep track of
the employee attendance. Time off / Time earned, excused / unexcused,
etc.

At my company from the 6th month of employment to the second year you
earn 8 hours of PTO each month, from the 2nd to 4th year you earn 10
hours PTO each month.

My question is how would I preform a check for each employee once a
month to automatically add their newly earned PTO time?

Something like - If today's date - employee A start date 7 months add
8 PTO hours etc.

I know I probably confused everyone reading this, but any help is
greatly appreciated.

I've got an even tougher problem for you. At my place of employment, as
a supervisor, I've used an ACCESS database I constructed to maintain my
employees time and attendance in such a way as to give me each of their
leave balances and tenure for any given day I enter into a dialog box
(form). There is an input form for entering each employee's annual, sick
and holiday leave taken, and also leave and tenure accrued. Where I
work, an employee who has between 0-5 years tenure earns 5 hours annual
leave each semi-monthly pay period; between 6-10 years, 6 hours; between
10-15 years 7 hours and for 15 years and up, 8 hours. And, every
employee earns 6 hours sick leave each pay period regardless of tenure.
Because there is a payday twice a month, this means leave accrues on
payday, which means some months it accrues on the 16th of the month and
others the 15th. I've never taken the time to automate this in my
database, so I have to enter leave and tenure accruals manually for each
employee every payday. I believe there should be a simple way to have
the database check the date on startup (use the VBA Date() function
perhaps) and have the Time_and_Attendance table update leave accruals and
tenure earned for each employee each month, perhaps through an Update
Query that executes via a macro triggered by the main form load event.
Does anyone have any experience in this area that can lend some advice as
to how this can be done?
Jan 13 '08 #4

This discussion thread is closed

Replies have been disabled for this discussion.