I've got this data that is imported in from excel and I'm struggling to clean it up in the most efficent way. Essentially, the question and answer are both populated in the field, and I'm trying to remove the question and also replace blanks. Here's how the data looks; it's one of these four:
Was the customer contacted? yes
Was the customer contacted? no
Was the customer contacted? n/a
Was the customer contacted?
I'm trying to update the above data to:
yes
no
n/a
unanswered
I'm really struggling to update the first three in tandem with the last one. Any suggestions? My field name is CustomerContacted.
I've attached an example DB as well.
Example22.accdb