correct syntax (2003)

Topic

New Reply

Dummy: IIF([Ctrl Plan] = 80782887, IIF([field] =5,5,””,IIF([Ctrl Plan] = 80782855, IIF([field]=7,7,””)

I want if Ctrl Plan = 80782887, If field = 5 – I want a 5 or null
If Ctrl Plan = 80782855, If field =7 – I want a 7 or null

If the above syntax correct?

Reply | Quote

Replies

Dummy: IIF([Ctrl Plan] = 80782887, IIF([field] =5,5,””,IIF([Ctrl Plan] = 80782855, IIF([field]=7,7,””)

I want if Ctrl Plan = 80782887, If field = 5 – I want a 5 or null
If Ctrl Plan = 80782855, If field =7 – I want a 7 or null

If the above syntax correct?

No, because it will return a Zero-Length String, not Null. Place your “” with the word Null.

Reply | Quote