Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2004
    Posts
    56

    Unanswered: first 10 characters in a record

    Simple to do I am sure but I haven't been successful. I am creating in a sort a "Shortname" search field and I need to take the first 10 letters of a one record and bring it over to another.

    So AcmeWidgetsInc
    becomes AcmeWidget

    Could someone please help me with the expression on this one.

    Thank you very much!

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    LEFT(yourField, 10)

  3. #3
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Also
    Mid(yourFiled,1,10)
    Or
    Mid$(yourFiled,1,10)

  4. #4
    Join Date
    Mar 2004
    Posts
    56

    Thank you

    thank you again!!

Posting Permissions

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