Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Posts
    17

    Unanswered: Retrieving last word in field

    Is there a function that will retrieve the last 'word' typed in a field.
    For example:

    "My name is Anna" = "Anna"
    "My father's age is 56" = "56"

    The function 'rightwords' doesn't seem to exist in Access. I use Access 2000 and the InStrRev isn't recognized.


    Thankyou for reading and eventually answering my question.
    Michèle

  2. #2
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Re: Retrieving last word in field

    Originally posted by MichèleW
    Is there a function that will retrieve the last 'word' typed in a field.
    For example:

    "My name is Anna" = "Anna"
    "My father's age is 56" = "56"

    The function 'rightwords' doesn't seem to exist in Access. I use Access 2000 and the InStrRev isn't recognized.


    Thankyou for reading and eventually answering my question.
    There is no such function in ACCESS but you can build it, usning the instr in a loop searching the space you could optain the position of the last space, then using the Mid Function you could get the last word in the string.

  3. #3
    Join Date
    Nov 2003
    Posts
    17
    Thanks hammbakka.
    All other suggestions are still welcome.
    Michèle

Posting Permissions

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