Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jul 2001
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Filter on Memo Field Contains Searchstring (Access 97(SR-1))

    I need to ristrict a recordset to records that contain a user specified search string somewhere in a memo field.

    Any ideas how to do it !

  2. #2
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Filter on Memo Field Contains Searchstring (Access 97(SR-1))

    If you use a parameter query the SQL would look like this:
    <pre>SELECT TBLNAME.COMMENTS
    FROM TBLNAME
    WHERE (((TBLNAME.COMMENTS) Like "*" & [ENTER SEARCH STRING:] & "*"));</pre>

    HTH

  3. #3
    New Lounger
    Join Date
    Jul 2001
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Filter on Memo Field Contains Searchstring (Access 97(SR-1))

    <img src=/S/bravo.gif border=0 alt=bravo width=16 height=30>

    Thanks Mark - I was being thick this morning (nothing new there then !)

    I will take the rest of the week off.

    Cheers!

Posting Permissions

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