Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2006
    Posts
    43

    Unanswered: Jr in Name Field moved to Suffix field

    I'm trying to find a way that if one of my customers has a Suffix in his name that it would remove it from the Name field and add it to the Suffix field.

    Any Idea's


    Before
    NAME LAST Suffix
    John Sr Smith
    JohnSir smith
    John III Smith
    John Jr Smith
    Sr John Smith
    Sr John Smith
    III John Smith
    Jr John Smith



    After
    NAME LAST Suffix
    John Smith Sr
    John Smith Sir
    John Smith III
    John Smith Jr
    John Smith Sr
    John Smith Sir
    John Smith III
    John Smith Jr

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Will it always be a FirstName Suffix LastName?

    Or will it sometimes simply be FirstName LastName?

    Will it ever be FirstName MiddleName LastName?

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  3. #3
    Join Date
    Nov 2006
    Posts
    43
    Thank you Orange999,

    Can you check the attachment. I think it will show you a better understanding of what I'm trying to do with live data to go off of.
    Attached Files Attached Files

Posting Permissions

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