Minty, you star, I'd tinkered with the brackets, but not to that extent.
Below is what worked
ActRecRate: IIf([TotalTime]=0,"No Hrs Booked",(IIf([Order Value]=0,"No Order Value",Format((([Order Value]-[expr2])/[TotalTime]),"Currency"))))
Thankyou
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...