[AccessD] Separating First and Last Names

If you have AccessXP (not sure if it is in lower versions), you could use
the Split function.

Doris Manning
Database Administrator
Hargrove Inc.
www.hargroveinc.com


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Coutts, Welford
L.
Sent: Monday, April 12, 2004 3:48 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Separating First and Last Names


I have received a large file containing a large number of Full Names. I need
to separate the First Name and Middle Initial, if any, into one field and
the Last Name into a separate field.
 
What is the most efficient way to do this?
 
Thanks!
 
Welford Coutts
 
 




-----------------------------------------
CONFIDENTIALITY NOTE:  This e-mail message, including any attachment(s),
contains information that may be confidential, protected by the
attorney-client or other legal privileges, and/or proprietary non-public
information.  If you are not an intended recipient of this message or an
authorized assistant to an intended recipient, please notify the sender by
replying to this message and then delete it from your system.  Use,
dissemination, distribution, or reproduction of this message and/or any of
its attachments (if
any) by unintended recipients is not authorized and may be unlawful.

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