Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2004
    Posts
    6

    Unanswered: Query using Text Searching problem

    I've got a query-by-form in which I want to pull up all records containing a particular keyword the user types in. My SQL in the query reads

    Like "*[Forms]![Query Form]![Text16]*"

    Unfortunately this doesn't work and my query returns nothing. But when my query reads

    Like [Forms]![Query Form]![Text16], it will return only the records that have the fied that matches the criteria exactly and not any records that have the keyword plus any other word that may be with the keyword. What is wrong with my coding? I'm going absolutely insane in the membrane!


  2. #2
    Join Date
    Jul 2004
    Location
    South Dakota
    Posts
    267
    If I'm understanding your problem correctly try this:

    Like "*" & [Forms]![Query Form]![Text16] & "*"

    Canupus

    Quote Originally Posted by batman124617
    I've got a query-by-form in which I want to pull up all records containing a particular keyword the user types in. My SQL in the query reads

    Like "*[Forms]![Query Form]![Text16]*"

    Unfortunately this doesn't work and my query returns nothing. But when my query reads

    Like [Forms]![Query Form]![Text16], it will return only the records that have the fied that matches the criteria exactly and not any records that have the keyword plus any other word that may be with the keyword. What is wrong with my coding? I'm going absolutely insane in the membrane!


  3. #3
    Join Date
    Jul 2004
    Posts
    6
    Thanks it worked GREAT!!!

  4. #4
    Join Date
    Jul 2004
    Posts
    6

    Thanks!

    I apologize for writing so late. The first time I wrote and tried to send the response, it wouldn't go through. Then it slipped my mind until now. But thank you so much for the help! It worked perfectly and now I can run my searches more efficiently.

Posting Permissions

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