Names Parse

[newbie123 via AccessMonster.com]

Hi!

I have searched through the postings on this site but can't seem to find a
solution - so hence this post.

I have a table where there is a field with the employee's name. The format
for the field is not identical:

1. LastName,FirstName MiddleInitial (note the space between FirstName and
MiddleInitial)
2. LastName-LastName,FirstName MiddleInitial (this is where individuals have
two last names, such as a married woman using her married-maiden last names).
3. LastName Suffix,FirstName MiddleInitial (suffix = Jr, III, etc).

Is there a query (or whatever it is called) that will strip of everything
after the FirstName (including the space) and give me only the LastName
(LastName-LastName, LastName Suffix),FirstName?

Thanks!

 

[newbie123 via AccessMonster.com]

Request no longer needed....got my answer.

Hi!

I have searched through the postings on this site but can't seem to find a
solution - so hence this post.

I have a table where there is a field with the employee's name. The format
for the field is not identical:

1. LastName,FirstName MiddleInitial (note the space between FirstName and
MiddleInitial)
2. LastName-LastName,FirstName MiddleInitial (this is where individuals have
two last names, such as a married woman using her married-maiden last names).
3. LastName Suffix,FirstName MiddleInitial (suffix = Jr, III, etc).

Is there a query (or whatever it is called) that will strip of everything
after the FirstName (including the space) and give me only the LastName
(LastName-LastName, LastName Suffix),FirstName?

Thanks!