Multicriteria Seach
Dec 17, 2005
I'm looking for a form to be filled by the user and then run a search in a table to find matching records. The idea is : the user fills what he can and the program searches all matching records. The form should contain several fields so the search would run on multiple criteria. Filled values filled could be ranges.
Certain fields (=criteria) could be optional.
Example :
name : begins with "SM"
forename : not filled (= all)
age : between 20 and 30
city : Tromso
experience (nb years) : > 3
This should already exist somewhere as a generic form; that's what I'm lloking for.
Thanks.
View Replies
Jun 22, 2006
I am a relatively novice access user with a question about a query I have built. The query is a parameter query that takes its query values from a form.
I have the query constructed at the moment so the user can search and any combination of fields using a date range, and three drop downs.
One of the fields in the table that I am querying is a text "Subject" field. I would like to add a keyword search upon this field into my existing query, as such I added a text box into my form, in which the user can type a keyword to search upon.
However, when I added the following criteria to the field in my query:
Like "*" & [Forms]![frm_find_log_entry]![Subject] & "*"
And then tried typing anything into my keyword search box on my form and run my query, I am returned with all results, rather than just results with the search words.
I have read a few strings on this subject. One from 2002 seemed to be on the right track but I was unable to understand it well enough to implement the suggested solution.
Any insight that could be provided on this subject would be greatly appreciated.
Thanks,
Benjamin
View 3 Replies
View Related
