Jim DeMarco
Jdemarco at hudsonhealthplan.org
Thu May 11 14:54:09 CDT 2006
Apologies. That code is not to be found at the moment. Jim D. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim DeMarco Sent: Thursday, May 11, 2006 3:43 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Splitting up names John, I've got a module that does just that including middle initial and pedigree. Let me know if you want it. Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Clark Sent: Thursday, May 11, 2006 2:22 PM To: accessd at databaseadvisors.com Subject: [AccessD] Splitting up names If got a user running a db in Access. She has a list of names and they were all input into a single "name" field, rather than "last name" & "first name." She would now like to split these names up, but there are some double first names, as well as "jr" and "sr" suffixes. Is there a way to do this? Basically names might be like this: JOHN SMITH JR MARY ELLEN SMITH BARBARA SMITH And I'd need to get them like this into a first name field like: JOHN MARY ELLEN BARBARA and a last name field like: SMITH JR SMITH SMITH John W. Clark Computer Programmer Niagara County Central Data Processing -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com