Currency in queries

[Amy]

I am running queries that have calculations in them and if
than statements and want to change the numbers into
currency. When I right click and select Properties and
select General-Format-Currency, it does not change to a
currency. Is there a way to get this to work?

 

[Paul Overway]

Use CCur, i.e.,

CCur(IIF(Condition,True,False))

 

[Amy]

What is you have the field left a null in some cases adn
then it reads error in this equation. Is there a way
around that?

This is the equation:

Value of Mobile Clinic: IIf([Location]="Carle/Mobile
Clinic",[Total On-Site Event Length]*20,IIf([Location]
="Other"," "))

Any ideas? When it is "Other" it reports an error. I
just want the field left blank.