Why am I getting the #Name error?

  • Thread starter Thread starter JWCrosby
  • Start date Start date
J

JWCrosby

This is probably embarrassingly simple, but I'm obviously missing something.

I have a field named EI_Exempt that is a yes/no field. On a form in the
detail section if I set a control source to EI_Exempt it will properly show
either a -1 or zero.

However, if I change it to a conditional statement (below) the control shows
"#Name" Here's the simple statement I'm using: (I have SUPER simplified my
intended formula just to troubleshoot and get by the #Name error. Once I get
past that I will input the proper If...then statement.)

=Iff([EI_Exempt]=-1,"Y","No")

Why is this throwing a #Name error?

Thanks in advance.

Jerry
 
Thanks, Bruce! You probably should have written, "It's IIf, not Iff,
STUPID!" and I would have deserved it! Ha!

Jerry

BruceM said:
It's IIf, not Iff.

JWCrosby said:
This is probably embarrassingly simple, but I'm obviously missing
something.

I have a field named EI_Exempt that is a yes/no field. On a form in the
detail section if I set a control source to EI_Exempt it will properly
show
either a -1 or zero.

However, if I change it to a conditional statement (below) the control
shows
"#Name" Here's the simple statement I'm using: (I have SUPER simplified
my
intended formula just to troubleshoot and get by the #Name error. Once I
get
past that I will input the proper If...then statement.)

=Iff([EI_Exempt]=-1,"Y","No")

Why is this throwing a #Name error?

Thanks in advance.

Jerry
Click to expand...
Click to expand...
 
Back
Top