Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    text query (2000)

    Never had to do this B4 - help! Need to look for any record containing the word "clean" . Can't seem to write the query correctly. What am I missing? Thanks.

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: text query (2000)

    In the criteria line of the column use
    <pre>Like "*clean*"</pre>

    If you want to retrieve it in more than one column, use the same criteria, but on a different line for each column.
    If needed, you can add new lines by selecting the Insert | Rows.
    Francois

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: text query (2000)

    Thank you, thank you, thank you. Works like a charm and I learned something new.

    Linda

Posting Permissions

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