Formatting a calculated field in a query to currency with no decimal points

[Owl]

I have a calculated field in a query which I want to format to Currency to 0 decimal points, either in the query or in the form which the query serves. I have an idea that it is something like Format$ but have not been able to guess how to apply it. I would like to know exactly where to put what, in relation to the fieldname and calculation, e.g.



FieldName:[Calculation])

Thank you for any help.

Owl

[orange]

see
http://office.microsoft.com/en-us/ac...001232740.aspx

[Owl]

Thank you for trying, but it wasn't there.

Please could somebody tell me what to put exactly where on my stylised example in the original question.

Thank you for any help.

Owl

[Owl]

I managed to sort this out myself.

I had tried every method I could think of and that worked on other calculated fields and couldn't understand why none of those ways were working on this one.

Then,, I removed the Nz function which hadn't been necessary anyway (), and hey presto! I was able to format it to Currency!

[orange]

For others who may be searching for the answer, perhaps you could show your solution.

[Owl]

I did.

As you will see in my previous reply, I removed the Nz function. That (possibly wrongly used) was what was preventing me from formatting the field in any of the normal ways (e.g. Format: Currency and Decimal Places: 0).