Search results for query: *

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

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

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

I will! Again, thanks.

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.

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

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.

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