Hi,
I need your help again... :) I'm working on access 2003. I have a query that calculate overtime daily using:
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.
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)
Could someone please help?
Thank you.
Comment