I have set the form field and the query field as currency, (or fixed) but the result is as a general number to many decimal places.
So i'm trying to format the "currency " in the number part of the expression below, but access tells me "Syntax error (comma) in the expression.
I'm trying to calculate a jobs recovery rate, but if the total time isn't entered, or the order value isn't entered there is a message, but if all is well a cost is returned.
ActRecRate: IIf([TotalTime]=0,"No Hrs Booked",(IIf([Order Value]=0,"No Order Value",(Format([Order Value]-[expr2])/[TotalTime])),"Currency"))
So i'm trying to format the "currency " in the number part of the expression below, but access tells me "Syntax error (comma) in the expression.
I'm trying to calculate a jobs recovery rate, but if the total time isn't entered, or the order value isn't entered there is a message, but if all is well a cost is returned.
ActRecRate: IIf([TotalTime]=0,"No Hrs Booked",(IIf([Order Value]=0,"No Order Value",(Format([Order Value]-[expr2])/[TotalTime])),"Currency"))