empty field-trying replace with word "none"

[techexpressinc]

i am trying to get when the field is not loaded spaces or null to replace it with the word none.

IIf([Notes]=" ","None",[Notes]) AS NOTES2,
IIf([Notes]=Null,"None",[Notes]) AS NOTES3


I do not see data in the field. And sometimes NOTES2 gets the word "None" sometimes not??

Never the NOTES3 gets "None".


Rneuman @ scaninc.org

 

[rainman89]

IIf(isnull([Notes]),"None",[Notes]) AS NOTES3

should work

 

[techexpressinc]

Much closer I am to the solution. THX.

That code is not catching with = " ". The field must have some that are spaces and some are nulls. I need a either or catcher.

This catches the spaces.
NOTES2: IIf([Notes]=" ","None",[Notes])

and this catches the nulls
NOTES3: IIf(IsNull([Notes]),"None",[Notes])

Can you help with the syntax to combine them??

Thx
Russ

 

[rainman89]

Try this

IIf(IsNull([Notes]),"None",(IIf([Notes]=" ","None",[Notes])))

 

[namliam]

Trim(nz(yourfield, "")) = ""

Try that