Re: Query part of string

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: John Vinson (jvinson_at_STOP_SPAM.WysardOfInfo.com)
Date: 09/27/04 

Date: Mon, 27 Sep 2004 15:13:54 -0600

On Mon, 27 Sep 2004 12:07:41 -0700, "Mary"
<anonymous@discussions.microsoft.com> wrote:

>Hello, I need to pull part of a field in a query. The
>field could have several notes, I only need to see then
>notes beginning with "Customer" on. That is the starting
>point I need to see without pulling anything that comes
>before that word. Is this possible?
>
>Thanks!

You're paying the penalty for improper table design! Fields should be
"atomic", having only one meaning. It's much easier to concatenate
multiple values into a paragraph than vice versa.

But if you have a memo field named [Notes] and you want to see
whatever comes after the first instance of the word Customer, you can
use

NewName: Mid([Notes], InStr([Notes], "Customer") + 9)

                  John W. Vinson[MVP]
             Join the online Access Chats
        Tuesday 11am EDT - Thursday 3:30pm EDT
      http://community.compuserve.com/msdevapps

Relevant Pages

  • Re: Unwanted table breaks across pages [word 2007]
    ... Only a whole Table Row (multiple lines) will move across the page break and not part of the row leaving some of the lines on one page and the remainder on the next. ... The reason for the way it is breaking is down to Paragraph Widows and Orphans. ... When it gets to the bottom of the page, ... the checkbox being clear. ...
    (microsoft.public.word.application.errors)
  • Re: Inserting Linebreaks...
    ... select the paragraph, go to FORMAT, PARAGRAPH, click the "Indents ... and Spacing" tab, and select the number of spaces you want in the ... This is a text in one language that flows over multiple lines in a ... (Assume this text covers multiple lines, ...
    (microsoft.public.word.general)
  • Re: How to look up a value in a list and return multiple corresponding values
    ... If you don't see the error message, there are more values to be returned, ... Please keep all correspondence within the NewsGroup, ... up a value and return multiple values (http://office.microsoft.com/en- ... return the first instance of a correponding value: ...
    (microsoft.public.excel.worksheet.functions)
  • Why does split operate over multiple lines in the absence of "ms" ? And why doesnt $_ work
    ... To substitute over multiple lines, ... will both split the entire paragraph, ... one assume that programmers would need to substitute only line 1, ...
    (comp.lang.perl.misc)
  • Re: Unwanted table breaks across pages [word 2007]
    ... Only a whole Table Row (multiple lines) will move across the ... The reason for the way it is breaking is down to Paragraph Widows ... the checkbox being clear. ...
    (microsoft.public.word.application.errors)