N
none
iif(isnull(x),"Unknown value",x)
it with a string such as "Unknown value". I would like to
do this as part of an SQL query which poulates the
rowsource of a list box. I do not want to update the
underlying data, the "Unknown value" text is for display
purposes in the list box only.
of a field to see if it is NULL and if it is then replace
it with a string such as "Unknown value". I would like to
do this as part of an SQL query which poulates the
rowsource of a list box. I do not want to update the
underlying data, the "Unknown value" text is for display
purposes in the list box only.