I am trying to divide time by quantity but the below formula does not work. Can someone help with the formula?
Expr1: [TimeCardDetail]![Time]\[ClosedWorkOrderCost]![LaborQty]
I am trying to divide time by quantity but the below formula does not work. Can someone help with the formula?
Expr1: [TimeCardDetail]![Time]\[ClosedWorkOrderCost]![LaborQty]
not 100% sure but i don't think it will be that simple. i think you have to convert to minutes first, then divide then convert back to hours. take a look at this and see what you think
http://allenbrowne.com/casu-13.html
Also, be aware that "Time" is a reserved word and shouldn't be used as object names. Plus "Time" is not very descriptive. "Time" of what??
And welcome to the forum......