Format as currency

[razorking]

Sigh....missing something easy again...damn, this frustrates me. Anyway, I have a query that has a field which is an expression. I want the result to display as currency. Ultimately this is going to be a control on a report. But I have tried formatting the control on the report as currecny and am having no success with that either. So if it is easier or better do do it on the report - fine - just hoping someone can give me an easy answer - because I'm sure the answer is easy and I am just daft.

Here is my query expression:
sales: IIf(IsNull([csales]),'0',([csales]))

 

[pbaldy]

Try this first:

sales: IIf(IsNull([csales]),0,([csales]))

and this is simpler:

sales: Nz([csales], 0)

 

[razorking]

Try this first:

sales: IIf(IsNull([csales]),0,([csales]))

and this is simpler:

sales: Nz([csales], 0)

Appreciate the suggestions, like them both but, it does not result in a currency format on the value returned..????

 

[raskew]

Hi -

Try carrying Paul's suggestion a step further:

Sales: format(Nz([csales], 0), "Currency")

Bob

 

[pbaldy]

Did you already put the currency format on the textbox? I assumed you had, and the quotes around the 0 would have caused the field to be treated as text. If that didn't work, this should:

sales: Format(Nz([csales], 0), "Currency")

 

[razorking]

That's it!

Thanks!