[AccessD] How to separate data of one field

Kostas Konstantinidis kost36 at otenet.gr
Sat May 28 10:06:33 CDT 2005


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 





More information about the AccessD mailing list