Change iif statement to ignore nulls?

[vbahelp07]

Hi all!
Happy New Year!

i can't figure out how to modify this query so that it will ignore nulls in the Description field?

Expr1: IIf([Description] Like "P/S*","Emplyr Match","401k Ded")

currently it updates ALL the nulls to say 401k Ded but i need to have the Descriptions left blank if there is no value in the first place.

i thought the Nz function but it's not working for me. i get an error msg. most likely my syntax.


Thank you in advance!

 

[lespaul]

well is it null or an empty string? maybe:

Expr1: IIf([Description] Like "P/S*","Emplyr Match", iif([Description] = "", [Description], "401k Ded"))

Leslie

In an open world there's no need for windows and gates

http://www.ubuntu.com

 

[LonnieJohnson]

Try...

IIf(IsNull([Description]),Null,IIF([Description] Like "P/S*","Emplyr Match","401k Ded"))

I didn't test it but it Should work.

ProDev, Builders of Affordable Software Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!

 

[genomon]

You mean like:

IIf(Nz([Description], "") Like "P/S*","Emplyr Match","401k Ded")

??

Alcohol and calculus don't mix, so don't drink and derive.

 

[vbahelp07]

wow everyone!

ok, they all look good. i will test and see which is best and report back

 

[vbahelp07]

ok, LonnieJohnson's worked. the others (probably "") is doing the same thing I was originally getting


thanks ALL!

 

[lespaul]

then that means it really IS Null and not an empty string....

 

[vbahelp07]

yes indeed