possible to format currency in iif query result that includes text?

[jorr]

Hi all,
Is it possible to format currency in the query expression with the results of an iif statement that includes text?
I want the retail currency result to include 2 decimal places and the currency symbol:


$###.##

My current expression is: Expr1: IIf(IsNull([Product Detail.Retail]),"Call Factory",([Product Detail.Retail]))

I found the following example:
FormatCurrency(Expression [, NumDigitsAfterDecimal ] [, IncludeLeadingDigit ] [,UseParensForNegativeNumbers ] [, GroupDigits ] )

at https://support.office.com/en-us/art...9-4e87a416b3d1

Is it possible to combine this into my expression? If so how?

Kind Thanks in advance!!

[June7]

Try:

IIf(IsNull([Product Detail.Retail]), "Call Factory", FormatCurrency([Product Detail.Retail]))