Amanda Rittenhouse
ajallen at mail.wvu.edu
Wed Sep 29 09:39:28 CDT 2004
Thank you. That worked perfectly. * Amanda >>> rbgajewski at adelphia.net 9/28/04 12:24:57 PM >>> Amanda Use the InStr function to locate the comma (or comma and following space) and then use the Left/Mid/Right functions to extract the portions on either side of the comma. Regards, Bob Gajewski -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Amanda Rittenhouse Sent: Tuesday, September 28, 2004 12:08 To: accessd at databaseadvisors.com Subject: [AccessD] Splitting Information from One field into Two I can't find my sample code where I update two fields by splitting one. I have a field NAME which contains: last name comma first name Example: Smith, John I want to create two fields: LastName FirstName I want to populate the two fields with the data from NAME. Before the comma is the last name and after the comma is the first name. I've seen the update code to do it but can not locate it now. Please help. * Amanda -- _______________________________________________ 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