Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by sfolland

  1. sfolland

    SQL statement will only search whole field

    Thanks Duane, I've been talking to someone local who suggested writing the query like this : [txtAuthors] & "~" & [txtTitle] & "~" & [txtSubjects] ... [txtTitle] & "~" & [txtAuthors] & "~" & [txtSubjects]... and joining the statements so that it would search using * between the keywords...
  2. sfolland

    SQL statement will only search whole field

    Perhaps I closed the post too soon... while this works: SELECT * FROM tblSingletonUrquhartLibraryCatalogue WHERE [txtAuthors] & "~" & [txtTitle] & "~" & [txtSubjects] & "~" & [txtDescription] Like "*" & [Enter Keyword] & "*"; - it only search one keyword. I've tried adapting it to make it...
  3. sfolland

    SQL statement will only search whole field

    No offense Frederico, but I think I was pretty clear in my request (especially considering my experience, as I noted). I asked a very specific question in regards to a statement that I'd written (and posted) and your response did not really address it. While I appreciate your advice, I don't...
  4. sfolland

    SQL statement will only search whole field

    I will! Again, thanks.
  5. sfolland

    SQL statement will only search whole field

    thank you & [thank.you];...I've been trying to resolve this one problem for 3 days, and your solution not only functions completely like I wanted it to but it also allows using * as a wildcard in the search, which is a totally unexpected suprise.
  6. sfolland

    SQL statement will only search whole field

    I want users to enter any term (accounting as an example)that will search all fields. This I've done using the following statement: SELECT * FROM tblSingletonUrquhartLibraryCatalogue WHERE [Enter Keyword] In ([txtAuthors],[txtTitle],[txtSubjects],[txtDescription]) The problem I'm having is...
  7. sfolland

    SQL statement will only search whole field

    Thanks Frederico, but I want the search to be user-entered so I don't want to enter the search terms in the statement. I've tried using Like "*" in the statement but this returns the entire database. Any suggestions? Stuart.
  8. sfolland

    SQL statement will only search whole field

    I'm trying to do a keyword search from multiple fields that will return results from any field that contains a keyword (eg. "accounting" to find any record with the word accounting in it). I'm only getting results from fields that contain just the word "accounting" but not "accounting -...
See more

Part and Inventory Search

Back
Top