Thank you for your response, MarkK.
I am still a beginner with using Access.
I agree that they way that I have set up the name is quite laborious. How would you propose to do it in one shot? If it can be done in one shot, then can the first, middle, and last name be in separate fields in the...