Windows XP, Access 2000
========================
Hi,

I have a table with a field for firstName and another for
lastName. Unfortunately, the suffixes for the person (eg.
Jr., II, RN, RD, PhD etc.) were entered along with the
last name. So, the lastName has data values like "Roberts,
RN" or "Clinton Jr.". I'd like to create another field and
then split the data to keep just the last name in the
lastName field, and the rest in the Suffix field.

Desired:
---------
lastName   | Suffix
====================
"Roberts"  |  "RN"
"Clinton"  |  "Jr."

I've looked at the string functions in the help section,
but didn't find any function that would help me accomplish
this. I guess I'm looking for something similar to
the "Data-->Convert Text to Columns" in MS Excel.

I could export the data from Access to Excel, split it,
and then import it back. But would prefer to do this
without importing/exporting data.

Thanks for any help or pointers regarding this.

-Amit