Syntax Issues

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
fgwiii said:
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
Click to expand...

Subeve: IIf([RDCIS]![DCI_NAME]=In("Page_03a", "Page_04", "Page_07"), "0" &
[RDCIS]![SUBEVENT],"")
 
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],"")))
 
Thanks - That did the trick!

Ofer Cohen said:
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


fgwiii said:
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
Click to expand...
Click to expand...
 
Back
Top