[AccessD] How to separate data of one field

Kostas - if it turns out to be a really big job then I read a very good review of this splitter tool a while back:

http://www.infoplan.com.au/splitter.htm

Kath
  ----- Original Message ----- 
  From: Kostas Konstantinidis 
  To: Access Developers discussion and problem solving 
  Sent: Sunday, May 29, 2005 1:06 AM
  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