Multiple IFF Statements help

  • Thread starter Thread starter Angelsnecropolis
  • Start date Start date
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 ^_^
 
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")))
 
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...
 
Back
Top