Tech Support Guy banner
Status
Not open for further replies.

Weekday formula in MS Access

809 views 3 replies 2 participants last post by  OBP 
#1 ·
I have a field where I can enter a date that someone worked and it will be overtime. If they work on Saturday, they will get paid time + 1/2. If they work on Sunday they will get paid double their normal pay. That being said, I want to enter the date (ie: 4/15/16) and then it can determine what day of the week that is. I have that part figured out. Now when it is a Saturday, I want to multiply the number of hours worked times 1.5 or if it is a Sunday I want to multiply the number of hours worked times 2. What would my formula be?
 
#3 ·
The whole sequence would be
1) enter date (4/16/16)
2) enter number of hours
3) automatically display the day of the week (I have that part figured out)
4) calculated field (number of hours x if(day of week = Sunday, 2, 1.5) x 25)) this would be currency

I am looking to capture the dollar amount spent on overtime
 
Status
Not open for further replies.
You have insufficient privileges to reply here.
Top