nested iif not working!!!!

[Becky]

I have an nested IIF that will only display one vlaue in my report section
footer. I am sure that this is a simple ( ) problem or something, but it is
very frustrating!

Here is the statement: =IIf((([combo16]="24"),"Total for Section
24"),IIf(([combo16]="DLSS"),"Total for DLSS"),IIf((([combo16]="DTS"),"Total
for DTS"),"Total for Section 65H"))

Here is the explanation:
Combo16 has 4 choices. My report is grouped by these choices. I have a
running total at each grouping. I want it to display Total for Section 24,
Total for 65H, Total for DLSS, etc but it only dispalys Total for DLSS in
that section-the rest are blank.

 

[David F Cox]

you want the alternatives in the else sections. You have your brackets mixed
up.
untested:
=IIf([combo16]="24","Total for Section
24",IIf([combo16]="DLSS"),"Total for DLSS",IIf([combo16]="DTS"),"Total
for DTS","Total for Section 65H")))

 

[John Vinson]

I have an nested IIF that will only display one vlaue in my report section
footer. I am sure that this is a simple ( ) problem or something, but it is
very frustrating!

Here is the statement: =IIf((([combo16]="24"),"Total for Section
24"),IIf(([combo16]="DLSS"),"Total for DLSS"),IIf((([combo16]="DTS"),"Total
for DTS"),"Total for Section 65H"))

Here is the explanation:
Combo16 has 4 choices. My report is grouped by these choices. I have a
running total at each grouping. I want it to display Total for Section 24,
Total for 65H, Total for DLSS, etc but it only dispalys Total for DLSS in
that section-the rest are blank.

Try using the Switch() function instead; it takes arguments in pairs,
and reads them left to right. When it first encounters a pair where
the first argument is True, it returns the second member of the pair
and quits:

=Switch([Combo16] = "24", "Total For Section 24", [Combo16] = "DLSS",
"Total for DLSS", [Combo16] = "DTS", "Total for DLSS", True, "Total
for Section 65H")

John W. Vinson[MVP]

 

[Becky]

Thank you for your answers....

For some reason the nested iif would still not work. I have never had one
not work like that, so I was surprised.

However, the switch worked like a dream! I guess I am going to have to
research those some more!

I have an nested IIF that will only display one vlaue in my report section
footer. I am sure that this is a simple ( ) problem or something, but it is
very frustrating!

Here is the statement: =IIf((([combo16]="24"),"Total for Section
24"),IIf(([combo16]="DLSS"),"Total for DLSS"),IIf((([combo16]="DTS"),"Total
for DTS"),"Total for Section 65H"))

Here is the explanation:
Combo16 has 4 choices. My report is grouped by these choices. I have a
running total at each grouping. I want it to display Total for Section 24,
Total for 65H, Total for DLSS, etc but it only dispalys Total for DLSS in
that section-the rest are blank.

Try using the Switch() function instead; it takes arguments in pairs,
and reads them left to right. When it first encounters a pair where
the first argument is True, it returns the second member of the pair
and quits:

=Switch([Combo16] = "24", "Total For Section 24", [Combo16] = "DLSS",
"Total for DLSS", [Combo16] = "DTS", "Total for DLSS", True, "Total
for Section 65H")

John W. Vinson[MVP]