J
Jack Sheet
Hi all
Re. Access 97.
I have a table containing a lot of records. In one field some of the
entries are blank, ie "null" entries.
I wish to replace all instances of blank records with the text string
"Other".
I tried to use Edit/Replace, but it requires a positive (non-"null") entry
in the "Find what" field of the Find/Replace dialog box before it will
proceed. I tried using two adjacent double-quotes but that did not help.
I tried sorting the database on that field so that all of the null entries
were grouped together, with the intention of blocking several records for a
single "paste", but it does not seem to let me block more than one record at
a time (without blocking the entire record rather than just one field).
Doubtless what I want can be done by VBA, but I feel there must be an easier
way.
Thanks
PS: please ignore text string "JS-Q3" in subject header.
Re. Access 97.
I have a table containing a lot of records. In one field some of the
entries are blank, ie "null" entries.
I wish to replace all instances of blank records with the text string
"Other".
I tried to use Edit/Replace, but it requires a positive (non-"null") entry
in the "Find what" field of the Find/Replace dialog box before it will
proceed. I tried using two adjacent double-quotes but that did not help.
I tried sorting the database on that field so that all of the null entries
were grouped together, with the intention of blocking several records for a
single "paste", but it does not seem to let me block more than one record at
a time (without blocking the entire record rather than just one field).
Doubtless what I want can be done by VBA, but I feel there must be an easier
way.
Thanks
PS: please ignore text string "JS-Q3" in subject header.