Posted on 1998-07-31
When creating a parameter query, how does one specify that the query should look for any combination of
words in the searched field? In other words, I have a database in which one of the fields is journal titles.
How would I create a parameter query that could find an entry like "The Kennedy Institute of Ethics Journal 1:2"
if the user supplied "Kennedy Institute Ethics," or maybe even just "Kennedy" to the query? Yes I'm new to Access. Thanks.