I want to blank out only some fields from a record, but do not know how. I tried case statements and if statements but am running into a wall. I would appreciate your help.
For those records with a confidentiality code=X, I want to blank out the names, but want to leave the other fields populated.
Record # Confidentiality Firstname Lastname Produce
1 Jane Smith apples
2 X oranges
3 X pears
4 John Deer grapes
What am I doing wrong?
Thank you for your time.
For those records with a confidentiality code=X, I want to blank out the names, but want to leave the other fields populated.
Record # Confidentiality Firstname Lastname Produce
1 Jane Smith apples
2 X oranges
3 X pears
4 John Deer grapes
What am I doing wrong?
Thank you for your time.