[AccessD] How to separate data of one field

....And for the code Helen Feddema has a demo using InStr which may help  in a sample called 'Split and Concatenate'. - vba code sample #37.

http://www.helenfeddema.com/CodeSamples.htm

Kath
  ----- Original Message ----- 
  From: Kath Pelletti 
  To: Access Developers discussion and problem solving 
  Sent: Monday, May 30, 2005 10:29 AM
  Subject: Re: [AccessD] How to separate data of one field 


  Kostas - will your database continue to need to parse the data or is it a one off? I was just thinking that if it is a one off then you could put it in Excel and given that you have commas as delimiters, the Excel 'Tools, Text to Columns' wizard is very good.

  If the function needs to be ongoing though then you'll need to code it...

  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
  -- 
  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