[AccessD] Splitting up names

Sure, create a name count field, so anything that isn't 2 goes at the top...

Drew

-----Original Message-----
From: Susan Harkins [mailto:harkinsss at bellsouth.net]
Sent: Thursday, May 11, 2006 5:02 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [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.


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com