Swapping text in a field

[Jason Walter]

I have a field in a database that is the legal name of a land owner.
Sometimes it has the spouse's name included and sometimes it has
something at the end like etal, or something similar.

Right now I manually pull out the first & second words in that field and
move them to there own fields. This gives me the first and last name
of the person.

Is there a macro or something that I can use to do this automatically?
If so, how would it work? I have other things linked to the query, such
as an automated link to a word document that prints a letter. I would
not want to mess that up.

Anyone know of some type of tutorial that would show an example similar
to this?

Thanks,
Jason Walter

 

[Ken Snell]

You could use an update query to do this if yo
--
Ken Snell
<MS ACCESS MVP>
u can easily identify how to parse the different parts of the names. You'd
likely use the Left, Mid, and Right functions to parse the text strings into
the separate parts so that they can be written into the other field(s).

Check this out in Help, and then post back if you have specific questions.