What Does +IIF Do as Opposed to IIF?

[james.igoe]

What Does +IIF Do as Opposed to IIF?

James Igoe
http://code.comparative-advantage.com/

['69 Camaro]

Hi, James.

What Does +IIF Do as Opposed to IIF?

It will concatenate a value to the preceding string if the IIF( ) function
evaluates to true. If the IIF( ) function evaluates to false, then the
preceding string value remains as is. This method is usually used with
columns that may contain NULL's, such as the middle initial in a person's
name, so that extra spaces aren't seen in the resulting calculated value.
For example, the following shows an extra space for the names that don't
contain a middle initial, because the code used to concatenate the first
name, middle initial, and last name didn't use the IIF( ) function in its
concatenation:

Bill M. Later
Faye Kennit
Justin Case

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
<ja********@gmail.comwrote in message
news:11**********************@v33g2000cwv.googlegr oups.com...

>
What Does +IIF Do as Opposed to IIF?

James Igoe
http://code.comparative-advantage.com/

['69 Camaro]

Hi, James.

Please don't multipost. There's already a discussion going on in another
newsgroup, so anyone answering this question of yours in this newsgroup
won't see the others' replies, nor they ours. It's a needless duplication
of effort. You should cross-post if you want the same question to appear in
more than one newsgroup and have everyone be aware of all the other replies
regardless of which newsgroup they posted to. For more information on
newsgroup ettiquette, please see the following Web page:

http://www.mvps.org/access/netiquette.htm

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
"'69 Camaro" <Fo**************************@Spameater.orgZERO_SP AMwrote in
message news:12*************@corp.supernews.com...

Hi, James.

>What Does +IIF Do as Opposed to IIF?

It will concatenate a value to the preceding string if the IIF( ) function
evaluates to true. If the IIF( ) function evaluates to false, then the
preceding string value remains as is. This method is usually used with
columns that may contain NULL's, such as the middle initial in a person's
name, so that extra spaces aren't seen in the resulting calculated value.
For example, the following shows an extra space for the names that don't
contain a middle initial, because the code used to concatenate the first
name, middle initial, and last name didn't use the IIF( ) function in its
concatenation:

Bill M. Later
Faye Kennit
Justin Case

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
<ja********@gmail.comwrote in message
news:11**********************@v33g2000cwv.googlegr oups.com...

>>
What Does +IIF Do as Opposed to IIF?

James Igoe
http://code.comparative-advantage.com/

[Bri]

ja********@gmail.com wrote:

What Does +IIF Do as Opposed to IIF?

James Igoe
http://code.comparative-advantage.com/

There is no such thing as +IIf. I think what you are seeing is a
calculation that includes the IIf function in it. + is the Add operator.

Show us the whole equation if this is still not clear to you.

--
Bri

[Tim Marshall]

Bri wrote:

There is no such thing as +IIf. I think what you are seeing is a
calculation that includes the IIf function in it. + is the Add operator.

On my A2003, the intellisense automatically changes +IIF to IIF,
droppping the plus sign.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Be Careful, Big Bird!" - Ditto "TIM-MAY!!" - Me