Null

[TONTA]

I am using Access to connect to a sybase (symposium) database... I pull records depending on what state the record was pegged.... This is based apon a user inpuyting a code on a telephone. Of the user puts a number that does not reprsent any of our set codes it will show the code feild as blank or null. I need to make this blank feild something representable as furhter down my querys it removes these blanks or nulls. I would like the blank field to be shown as "Bad Code"

Any help would be great...

p.s I have used iif and as and like and nothing is working..

Ta

 

[IgorB]

IIF([YourFieldName] is not null,[YourFieldName],"Bad Code")

or try also

IIF(Len([YourFieldName])>0,[YourFieldName],"Bad Code")



Igor.