automate a formula ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

Ok so i placed this question on a previous post and i
would like to know if a macro could run to be
able to calculate how many hours an employee has left for
vacation.For example, 10 employee with each having 200
hours a year for vacation.How would the calculation work
in reducing each employees 200 hours as they are taken?I
already have a field for (hours not worked) and a drop
down field for the codes(v for vacation,p for personal or
o for other.Would this be a calculated field or do i
create a formula and have a macro event run after an
employee number entry? Any help would be
appreciated...thanks
 
Ill go altra detailed on you.

Have a empolyee table with an employee # and the a bunch
of fields about the employee, including a field that
indicates the # of hours available to vacation per year.

Have another table where a new record is added everytimee
the employee vacations.

The create a query to sum the vacations and compare to
their max time permitted.

Then make a report.

Each empolyee should have a
 
Back
Top