[AccessD] How to separate data of one field

Kostas

Use the InStr function to separate the names by the comma (tmpName1,
tmpName2, etc - perhaps use an array?), then use it again on each name to
separate the first and last names by the space (tmpFirstName, tmpLastName).
Once separated, you can concatenate back with a comma (txtFullName =
tmpLastName & ", " & tmpFirstName). This only works if your names are
consistently in the original field as you described.

Regards,
Bob Gajewski


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kostas
Konstantinidis
Sent: Saturday, May 28, 2005 11:07 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] How to separate data of one field 

dear group...
I have two questions:

1) Into a field I keep names and in many cases there are two or either three
names into the same field e.g.
George Papas, John Stevenson, Jack Bolt
what I want to do is to separate that field into two or three depenting by
the "comma" like George Pappas John Srevenson Jack Bolt

2) How is possible to appear first the Last name instead of the First name
First name, Last Name to Last Name, First Name

thank's a lot
/kostas 


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