Currency in queries

  • Thread starter Thread starter Amy
  • Start date Start date
A

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?
 
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.
 
Back
Top