• Manipulate Text Function (Access97)

    Author
    Topic
    #378779

    Does there exist a function that will take a Name field (text) and allow me to parse out the first characters until it encounters a space or a comma? Or is there a modification of the left, right, or mid functions that can accomplish this?

    Specifically I have a LName field that in some cases has a Suffix, sometimes it is Loween, Jr. other times it is Loween III, either way, I only want the Loween.

    As always… Thanks a bunch. Jenn. Happy Treating

    Viewing 0 reply threads
    Author
    Replies
    Viewing 0 reply threads
    Reply To: Manipulate Text Function (Access97)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: