I have a field formated as general. The field contains either 1 or is left
blank. If the field has a 1 I want to replace it with Yes and if the field
is blank I want to replace it with No.

any help is appreciated.
--
Jerry