Multiple IFF Statements help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Angelsnecropolis - 29 Nov 2008 23:58 GMT

I need to get this to work:

=IIf(Forms.[Helpgate Menu].replist is null And Forms.[Helpgate Menu].Mgrlist
Is Null,"Questions - All Reps"),iff(Forms.[Helpgate Menu].Mgrlist Is not Null
and Forms.[Helpgate Menu].Replist is null,"Questions - Per
MGR"),iif(Forms.[Helpgate Menu].replist Is not Null and Forms.[Helpgate
Menu].Mgrlist is null,"Questions - Per Rep")

Thanks in advance ^_^

Reply to this Message

Ken Snell (MVP) - 30 Nov 2008 01:08 GMT

Too many ) characters in the wrong places, and not enough in the right
places:

=IIf(Forms.[Helpgate Menu].replist is null And Forms.[Helpgate Menu].Mgrlist
Is Null,"Questions - All Reps",iff(Forms.[Helpgate Menu].Mgrlist Is not Null
and Forms.[Helpgate Menu].Replist is null,"Questions - Per
MGR",iif(Forms.[Helpgate Menu].replist Is not Null and Forms.[Helpgate
Menu].Mgrlist is null,"Questions - Per Rep")))

Signature

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/

>I need to get this to work:
>
[quoted text clipped - 7 lines]
>
> Thanks in advance ^_^

Reply to this Message

Ken Snell (MVP) - 30 Nov 2008 14:06 GMT

And I missed the too obvious "iff" -- it should be "iif"

=IIf(Forms.[Helpgate Menu].replist is null And Forms.[Helpgate Menu].Mgrlist
Is Null,"Questions - All Reps",IIf(Forms.[Helpgate Menu].Mgrlist Is not Null
and Forms.[Helpgate Menu].Replist is null,"Questions - Per
MGR",IIf(Forms.[Helpgate Menu].replist Is not Null and Forms.[Helpgate
Menu].Mgrlist is null,"Questions - Per Rep")))

Signature

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/

> Too many ) characters in the wrong places, and not enough in the right
> places:
[quoted text clipped - 18 lines]
>>
>> Thanks in advance ^_^

Reply to this Message

tina - 30 Nov 2008 01:09 GMT

already posted in microsoft.public.access.formscoding under Subject line "
Whats wrong with this code?"

please don't multi-post. for more information, see
http://home.att.net/~california.db/tips.html#aTip10

hth

> I need to get this to work:
>
[quoted text clipped - 5 lines]
>
> Thanks in advance ^_^

Reply to this Message