Nested IIF Statement in a query

[FrankTimJr]

I'm trying to set up a nested IIF statement in a query and I'm striking out.

Basically I'm trying to do the following:

If "Field A" and "Field B" are both blank, "Enter This Text" OR If "Field A"
is NOT blank, "Enter That Text".

Any ideas??
Thanks in adavnce.
Frank

 

[Stefan Hoffmann]

hi Frank,

I'm trying to set up a nested IIF statement in a query and I'm striking out.

Basically I'm trying to do the following:

If "Field A" and "Field B" are both blank, "Enter This Text" OR If "Field A"
is NOT blank, "Enter That Text".

Iif(Len(Trim(Nz([FieldA], ""))) > 0,
"Enter That Text",
Iif(Len(Trim(Nz([FieldB], ""))) = 0), "Enter This Text", "???")

mfG
--> stefan <--

 

[Allen Browne]

You haven't indicated what to do if A is blank and B is not.
Assuming you leave the text blank for this column, perhaps something like
this:

IIf([A] Is Null, IIf( Is Null, "Enter this text", Null), "Enter that
text")

 

[Daryl S]

Frank -

You didn't say what the result should be for when A is null and B is not, so
I made something up for that. Here goes:

IIF(isnull([Field A]),iif( isnull([Field B]),"Enter This Text","A null B not
null"),"Enter That Text")

 

[John Spencer]

IIF([FieldA] is Null and [FieldB] is Null,"Both Null"
, IIF([FieldA] is not null,"Field A has a Value",
, IIF([FieldB] is not null,"Field B has a Value",Null)))

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County