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...
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 -...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.