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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate Hours Query 3
Access Using Parameters and Criteria in Access 2003 0
calculating Sick pay entitlement 1
non-numeric in a calculation 1
Query Parameters 1
Formula incomplete 2
if statement = if number is between 1
Is anyone up for a Challenge? Oh I HOPE SO!!!! 8

Back
Top