How to format a field with with currency operators

[ecorg911]

Hello, I am having a few problems with a calculated field I am using in a query:

Result: IIf([Units in stock]>100,0.75*[Unit Price],0)

When the field outputs, it appears in decimal formatting, how would you change it to currecny formatting?

P.S. I realise this operation is straight forward on a table, although I am not sure how to accomplish this in a query.

Any help would be greatly appreicated

Thanks

 

[Brianwarnock]

In the design grid right click on the field, select properties from the menu, select format, then currency

Brian

 

[ecorg911]

In the design grid right click on the field, select properties from the menu, select format, then currency

Brian

Cheers mate