IIf statement help

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")
 
B

Ben

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
 
R

Ron2006

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")))
 
G

Golfinray

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Nested IIF AND statements 4
multiiple iif statements in a report query 0
Time in calculated field for shifts going past midnight 0
iif, or, else? 3
Nested If conversion to Select case 5
iif statement what is wrong with this expression 2
Choose append field based on criteria 4
Getting rid of a Having clause 1

Top