formula for who is from monsey

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i'm trying to make an iif formula for a report that if the student is from
monsey it should say "as you are living near to our premises" and if not it
should say "as you aren't living near to our premises"
I tried this but it didn't work
=iif(([Student Country]="Monsey"),"as you are living near to our
premises","as you aren't living near to our premises")
Please can someone help me.
 
"It didn't work" does not tell us anything.

What DID it do?

Where did you put this? In the detail section, in an unbound text box? Did
you mena to do student COUNTRY or COUNTY?
 
Try changing aren't to are not. I think that little apostrophe is screwing
it up.

UpRider

Database User said:
It just said has 2 many arguments

Database User said:
i'm trying to make an iif formula for a report that if the student is
from
monsey it should say "as you are living near to our premises" and if not
it
should say "as you aren't living near to our premises"
I tried this but it didn't work
=iif(([Student Country]="Monsey"),"as you are living near to our
premises","as you aren't living near to our premises")
Please can someone help me.
Click to expand...
Click to expand...
 
Back
Top