LookUp Table

  • Thread starter Thread starter open a adobe file from a command button
  • Start date Start date
O

open a adobe file from a command button

I want to monitor how much vacation time a person in the office has but we
all accrue it at different rates. A person that has worked for the company
for less than 5 years earns 2.5 hours per pay period, 5-10 earns 3.7 and more
than 10 earns 4.7. Can I create a “LookUp†table based on a persons Date Of
Hire to determine how much vacation hours to calculate from.
 
There are many factors that would influence the choice of the best approach
for this.

Firstly, you will need a table with the values to look up, e.g.:
MinYears MinutesPerPayPeriod
0 150
5 222
10 282
(I'm suggesting you store this as minutes to facilite date/time calculations
and avoid rounding errors.)

Presumably your Employee table has a DateOfHire field. You can therefore
calculate the number of years of service, and get the Minutes for that
number of years. The calculation of number of years will be similar to this
calculation of years:
http://allenbrowne.com/func-08.html

You may also need this info to create a query that gives you the MaxYears as
well:
http://allenbrowne.com/ser-58.html

And to get the number of hours into your main query, you will need a
subquery:
http://allenbrowne.com/subquery-01.html
or a DLookup() expression:
http://allenbrowne.com/casu-07.html

Now to put those techniques to good use. Presumably you have a table where
you record the number of hours per employee per pay period, and the pay
rate. So you could add another field to that table to store the number of
hours accrued, and have this calculated and stored as part of that record.
It's not clear here how you handle part timers, e.g. whether their a person
who works half time gets half the number of hours per period.

You will also need to provide a way to record when an employee takes leave,
so you can subtract the number of hours actually taken from the number of
hours due.

There will also be other complicating factors, such as sick leave or
compassion leave which may also need to be stored and accumulated, and
possibly lost after a period if not used without losing the accumulated
holiday leave, provision for long service leave, and handling cases where
accumulated leave may be cancelled (e.g. if the employee is found guilty of
fraud.)

You may need to check out what laws apply where you live, but don't forget
that these laws may change over the years, so you may find there are some
laws applying to leave accumulated before a certain date, and other laws
after that time.

So, there's plenty to think about. :-)

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

"open a adobe file from a command button"
 
Thank You. Most of what you say I somewhat understand, implementing it is
something else, can I hire you to help me with this project??

Thanks
 
Thanks for the offer, but we are fully booked up for the next 6 months.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

"open a adobe file from a command button"
 
Back
Top