Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2002
    Posts
    173

    Unanswered: seperating names

    I have a field that lists names in the following format:

    lastname, firstname middleinitial
    ie.
    smith, bob f

    Sometimes there is no middle initial sometimes there is. I'd like to make a "make table query" that would seperate these somehow. Does anyone know how to accomplish this?

  2. #2
    Join Date
    Aug 2002
    Location
    Northampton, England
    Posts
    266
    Use a select query to extract the names and initials.
    FName: Right$([YourFieldName],Len([YourFieldName])-InStr(1,[YourFieldName],","))

    This will extract the first name/s and initials.

    LName: Left$([YourFieldName],InStr(1,[YourFieldName],",")-1)

    This will extract the surname.

    Run your make table query from this.

    David

  3. #3
    Join Date
    Jun 2002
    Posts
    173
    Is there a way to pull out that middle initital? Sometimes the data has a middle initial sometimes it doesn't. I'm not sure if this poses any kind of problem.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •