If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Help with calculation flow days
Hello,
I got a query that I try to calculate the number of days at several operation, but not sure how to go about calculating in query. In the query I got the field for order#, workcenter, oper#, finishdate and other. I would like to calculate number of work days exluding holiday at each workcenter. sample data: order# oper workcenter finishdate 0110 5 ABC 1/1/08 0110 10 ABC 1/3/08 0110 20 ABC 1/4/08 0110 30 ZZZ 1/6/08 0110 40 DVD 1/7/08 0110 50 DVD 1/9/08 0110 70 VHR 1/14/08 Results would like to acheive: workcenter oper #ofdays ABC 5, 10, 20 4 (1/1/08 to 1/4/08) ZZZ 30 1 (1/4/08 to 1/6/08: 1/5 & 6 weekend) DVD 40, 50 3 (1/6/08 to 1/9/08) VHR 70 3 (1/9/08 to 1/14/08: 1/12 & 13 weekend) To calculate the flow days, I used the following formula in Excel, but not sure how to translate that into Access. =NETWORKDAYS($O7,$O8,Holiday!$A$2:$A$24) Thanks so much for any help. |
Thread Tools | |
Display Modes | |
|
|