Hello everyone,

I'm trying to put together an IIF statement that goes something like this

iif ([field1] = 51245 then go to ([field2]
and put "156354"

iif ([field1] = 12548 then go to ([field2]
and put "2586487"

iif ([field1] = 357159 then go to ([field2]
and put "5689562"

iif ([field1] = 9273568 to ([field2]
and put "862214"

So basically I'm saying that is a certain number shows up in field one then go to field two and out a certain number in there

or kind or like:
Program ID: IIf([sent]=51459,([Program_ID]),"1667200")

Thank you for any help

Corey

Hi Corey

Think you'll find the IIF statement below will work
IIf([Field1]=51245,156354,IIf([Field1]=12548,2586487,IIf([Field1]=357159,5689562,IIf([Field1]=9273568,862214,""))))

Where there is "" at the end can be left or put an alternative in there. I did this as numbers, you can change to text or a mixture if you want. THis need to be placed in an updated query against Field2 to work.

Hope this helps

Martin

Awesome - Works great!!!!

Thanks a lot Martin