Multiple IFF Statements help

[Angelsnecropolis]

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 ^_^

 

[Ken Snell \(MVP\)]

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

 

[tina]

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

 

[Ken Snell \(MVP\)]

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

--

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

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

--

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

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 ^_^