IIf statement help

  • Thread starter Thread starter Golfinray
  • Start date Start date
G

Golfinray

Can't get my IIF statement to work. I know I'm missing something simple. Help!
Funding:
IIf([cp_funding_id]=1,"partnership"),IIF([cp_funding_id]=0,"local"),IIF([cp_funding_id]is null,"partnership")
 
Your parenthesis is not correct, try this:

IIf([cp_funding_id]=1,"partnership",
IIF([cp_funding_id]=0,"local",
IIF([cp_funding_id]is null,"partnership")))

Ben
 
Can't get my IIF statement to work. I know I'm missing something simple. Help!
Funding:
IIf([cp_funding_id]=1,"partnership"),IIF([cp_funding_id]=0,"local"),IIF([cp­_funding_id]is null,"partnership")
Click to expand...



IIf([cp_funding_id]=1,"partnership",IIF([cp_funding_id]=0,"local",IIF
([cp­_funding_id]is null,"partnership","Unknown")))
 
DUH! What was I thinking? That did it, thanks.

Ben said:
Your parenthesis is not correct, try this:

IIf([cp_funding_id]=1,"partnership",
IIF([cp_funding_id]=0,"local",
IIF([cp_funding_id]is null,"partnership")))

Ben


Can't get my IIF statement to work. I know I'm missing something simple. Help!
Funding:
IIf([cp_funding_id]=1,"partnership"),IIF([cp_funding_id]=0,"local"),IIF([cp_funding_id]is null,"partnership")
Click to expand...
Click to expand...
 
Back
Top