HI,

I'm using an IIf statement in a calculated field in a query, and the result won't give the option of changing the format of the field. This is the statement:

FOBCost2: IIf(tblQuotes!FOB="Delivered",[FOBCost],"0")

FOB is a text field and FOBCost is a currency field. Is there any way to fix this so that the result can be set to currency as well?

Thanks,

Adam

Try dropping the quotes around the zero so it's not treated as text.

If Pauls suggestion doesn't work, maybe...........

FOBCost2: FormatCurrency(IIf(tblQuotes!FOB="Delivered",[FOBCost],0))

Dropping the quotes worked great!

Thank you for your fast responses!

Adam