If Then or IIF

  • Thread starter Thread starter Stefan
  • Start date Start date
S

Stefan

Can someone please help me with some code.

I have field [Attending Provider] that could contain one
of four values.

DGKON DGHIL DWKON DWHIL

IF THE FIELD = DGKON OR DGHIL I WOULD LIKE TO RETURN THE
VALUE "DARRELL"
IF THE FIELD = DWKON OR DWHIL I WOULD LIKE TO RETURN THE
VALUE "INCIDENT TO"

I TRIED

PROVIDER:IIF([Attending Provider]= "DGKON","DARRELL",IIF
([Attending Provider]="DGHIL","DARRELL","INCIDENT TO")

I COULDN'T GET THE SYNTAX CORRECT.

ANY HELP WOULD BE GREATLY APPRECIATED.
 
Stefan said:
Can someone please help me with some code.

I have field [Attending Provider] that could contain one
of four values.

DGKON DGHIL DWKON DWHIL

IF THE FIELD = DGKON OR DGHIL I WOULD LIKE TO RETURN THE
VALUE "DARRELL"
IF THE FIELD = DWKON OR DWHIL I WOULD LIKE TO RETURN THE
VALUE "INCIDENT TO"

I TRIED

PROVIDER:IIF([Attending Provider]= "DGKON","DARRELL",IIF
([Attending Provider]="DGHIL","DARRELL","INCIDENT TO")

I COULDN'T GET THE SYNTAX CORRECT.

ANY HELP WOULD BE GREATLY APPRECIATED.
Click to expand...

PROVIDER:IIF([Attending Provider] IN ("DGKON","DGHIL"),"DARRELL","INCIDENT
TO")
 
Back
Top