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

hi Frank,

On 22.01.2010 15:34, FrankTimJr wrote:
> 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 <--

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([B] Is Null, "Enter this text", Null), "Enter that 
text")

-- 
Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"FrankTimJr" <FrankTimJr@discussions.microsoft.com> wrote in message 
news:A6EB05D6-9956-4C41-A343-2DEF57DBDB67@microsoft.com...
> 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 

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")

-- 
Daryl S


"FrankTimJr" wrote:

> 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

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

FrankTimJr wrote:
> 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