Search results

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...