By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,665 Members | 2,802 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,665 IT Pros & Developers. It's quick & easy.

Calculate Overtime for Saturday and Sunday

P: 25

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

Expand|Select|Wrap|Line Numbers
  1.  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.
Feb 10 '10 #1
Share this Question
Share on Google+
1 Reply

P: 25
Never mind... I figured it out.. thanks.. :)
Feb 10 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.