If Statement

[Glenn Dulmage]

I have a Checkbox field [Membership 04-05] which returns a 0 or a 1
depending on whether it is checked. I am trying to print a label in which I
would like a YES or NO to appear instead of the 0 or 1. I have tried the
following:

="Member:" & IIf(([Membership 04-05])="1","","YES") or IIf(([Membership
04-05])="0","","NO")

Surprise, surprise - it doesn't work. Can anyone help?

Thanks
--
Glenn T. Dulmage
207 Valley Road
Chestertown MD 21620
410-778-5166
(e-mail address removed)

 

[Lynn Trapp]

Try it this way instead.

="Member:" & IIf([Membership 04-05]= -1,"YES","NO")

 

[Glenn Dulmage]

WOW! Not only works like a charm, but your answer came back in less than 10
minutes!!

Question: why the -1 after the = ?

I can't thank you enough

Try it this way instead.

="Member:" & IIf([Membership 04-05]= -1,"YES","NO")

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

I have a Checkbox field [Membership 04-05] which returns a 0 or a 1
depending on whether it is checked. I am trying to print a label in which I
would like a YES or NO to appear instead of the 0 or 1. I have tried the
following:

="Member:" & IIf(([Membership 04-05])="1","","YES") or IIf(([Membership
04-05])="0","","NO")

Surprise, surprise - it doesn't work. Can anyone help?

Thanks
--
Glenn T. Dulmage
207 Valley Road
Chestertown MD 21620
410-778-5166
(e-mail address removed)

 

[Lynn Trapp]

You're quite welcome.

In Access the values of a boolean (yes/no) field are 0 = False and -1 =
True.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

WOW! Not only works like a charm, but your answer came back in less than 10
minutes!!

Question: why the -1 after the = ?

I can't thank you enough

Try it this way instead.

="Member:" & IIf([Membership 04-05]= -1,"YES","NO")

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

I have a Checkbox field [Membership 04-05] which returns a 0 or a 1
depending on whether it is checked. I am trying to print a label in

which
I

would like a YES or NO to appear instead of the 0 or 1. I have tried the
following:

="Member:" & IIf(([Membership 04-05])="1","","YES") or IIf(([Membership
04-05])="0","","NO")

Surprise, surprise - it doesn't work. Can anyone help?

Thanks
--
Glenn T. Dulmage
207 Valley Road
Chestertown MD 21620
410-778-5166
(e-mail address removed)

 

[Sprinks]

Hi,

Hi, Glenn. Assuming that 1 corresponds to "YES", try:

="Member:" & IIf(([Membership 04-05])="1","YES","NO")

The syntax of IIF function is IIF(booleanstatement,value if true,value if
false).

Hope that helps.
Sprinks