[AccessD] Splitting up names

I was thinking the same thing Drew -- you can automate the split, but with
inconsistent values to start with, there's no substitute for the human
review to clean up the few that just don't fit. You might could even flag
the ones that seem inconsistent to help out a bit. 

Susan H. 

The Split() function will split them into a string array, however, the JR
and two name first names are going to be an issue.  I would create a list of
known suffixes, and then create a suffix field.  Whatever you do is going to
probably require a human to 'review' the results.