Calculate Overtime for Saturday and Sunday

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Bay0519
    New Member
    • Jun 2009
    • 25

    Calculate Overtime for Saturday and Sunday

    Hi,

    I need your help again... :) I'm working on access 2003. I have a query that calculate overtime daily using:

    Code:
     IIf([totalhours]<=8,0,[totalhours]-8)
    but how can I add saturday and sunday in this criteria? if someone worked on saturday or sunday, it'll calculate as overtime.

    Could someone please help?

    Thank you.
  • Bay0519
    New Member
    • Jun 2009
    • 25

    #2
    Never mind... I figured it out.. thanks.. :)

    Comment

    Working...