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!

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

Search results for query: *

  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

    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.
  5. 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...
  6. 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.
  7. 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 -...

Part and Inventory Search

Back
Top