adding based on certain criteria

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

Guest

I have a query that calculates the number of hours worked, sick days
entitled, sick days used and sick days remaining. The problem is that for
our p/t staff they get 3 paid sick days but after working 1700hrs they get an
additional 2. I can't figure out the formula that will automatically add the
2 sick days for only the p/t staff after they have worked 1700hrs. There is
a field in the query that does identify who is f/t or p/t. Any help on this
would be greatly appreciated.
 
I tried that but still couldn't get it to add the 2 extra days, but I did
add a text box to the form that I conditionally formatted to show a message
when the person has reached 1700hrs reminding that that person is now
entitled to 2 extra days.
Thanks
 
Back
Top