I am trying to create an update query to correct the names of one table before comparing it with the other. The problem is, I have four people with the suffix of Jr. on their last name. I want to get rid of the "." without having to list each name indiviually. Is there a way I can do this? I tried using "<> Right([Name_Last,1)" function to delete, but It doesn't work and I do not know how to delete. Is there a delete command? I've tried delete, remove, exclude, etc. Please help.
Here is an example of my query.
IIf([Name_Last]="Smithy","Smith",IIf([Name_Last]="Davisy","Davis",IIf([Name_Last]="Jonesy","Jones",IIF([Name_Last]Like "*.",<>(Right([Name_Last],1)),[Name_Last]))))
Here is an example of my query.
IIf([Name_Last]="Smithy","Smith",IIf([Name_Last]="Davisy","Davis",IIf([Name_Last]="Jonesy","Jones",IIF([Name_Last]Like "*.",<>(Right([Name_Last],1)),[Name_Last]))))