Multiple IFF Statements help

A

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

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

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/



Ken Snell (MVP) said:
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/


Angelsnecropolis said:
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 ^_^
Click to expand...
Click to expand...
 
Top