Syntax Issues

[fgwiii]

I attempting to do the following

Subeve: IIf([RDCIS]![DCI_NAME]="Page_03a","0" & [RDCIS]![SUBEVENT],"")
else IIf ([RDCIS]![DCI_NAME]="Page_04","0" & [RDCIS]![SUBEVENT],"")
else IIf ([RDCIS]![DCI_NAME]="Page_07","0" & [RDCIS]![SUBEVENT],"")

But I do not know the proper syntax.

Please help,

Fred

 

[Rick Brandt]

I attempting to do the following

Subeve: IIf([RDCIS]![DCI_NAME]="Page_03a","0" & [RDCIS]![SUBEVENT],"")
else IIf ([RDCIS]![DCI_NAME]="Page_04","0" & [RDCIS]![SUBEVENT],"")
else IIf ([RDCIS]![DCI_NAME]="Page_07","0" & [RDCIS]![SUBEVENT],"")

But I do not know the proper syntax.

Please help,

Fred

Subeve: IIf([RDCIS]![DCI_NAME]=In("Page_03a", "Page_04", "Page_07"), "0" &
[RDCIS]![SUBEVENT],"")

 

[Ofer Cohen]

Try nested iif

IIf(criteria, then , iif(critera, then, iif(criteria, then,else)))

Subve: IIf([RDCIS]![DCI_NAME]="Page_03a","0" & [RDCIS]![SUBEVENT],IIf
([RDCIS]![DCI_NAME]="Page_04","0" & [RDCIS]![SUBEVENT],IIf
([RDCIS]![DCI_NAME]="Page_07","0" & [RDCIS]![SUBEVENT],"")))

 

[fgwiii]

Thanks - That did the trick!

Try nested iif

IIf(criteria, then , iif(critera, then, iif(criteria, then,else)))

Subve: IIf([RDCIS]![DCI_NAME]="Page_03a","0" & [RDCIS]![SUBEVENT],IIf
([RDCIS]![DCI_NAME]="Page_04","0" & [RDCIS]![SUBEVENT],IIf
([RDCIS]![DCI_NAME]="Page_07","0" & [RDCIS]![SUBEVENT],"")))


--
Good Luck
BS"D

I attempting to do the following

Subeve: IIf([RDCIS]![DCI_NAME]="Page_03a","0" & [RDCIS]![SUBEVENT],"")
else IIf ([RDCIS]![DCI_NAME]="Page_04","0" & [RDCIS]![SUBEVENT],"")
else IIf ([RDCIS]![DCI_NAME]="Page_07","0" & [RDCIS]![SUBEVENT],"")

But I do not know the proper syntax.

Please help,

Fred