Attendance Database - Help with PTO Time

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.

Re: Attendance Database - Help with PTO Time

On Sat, 12 Jan 2008 17:44:31 -0800 (PST), lucky33
wrote:

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.

Re: Attendance Database - Help with PTO Time

On Sat, 12 Jan 2008 19:12:03 -0700, Tom van Stiphout wrote:

> On Sat, 12 Jan 2008 17:44:31 -0800 (PST), lucky33
> wrote:
>
> 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?

Re: Attendance Database - Help with PTO Time

On Sun, 13 Jan 2008 02:35:10 GMT, Don Calloway
wrote:

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
>> wrote:
>>
>> 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?