I am looking for clues on how to run a character string search using a parameter query. As it stands for each field on a form I have the following criteria:
WHERE (((table.example) Like [Forms]![query]![field] & "*"));
This returns only those strings that have the wildcard as the first character of the string. For example if the user inputs "a" into the form field that will return all strings that "start" with the letter a.
What I want to do is return ALL strings that "contain" the letter "a"
So if 5 fields contain the words: and, atom, bath, rain, lama
it will return all five words not just "and" and "atom"
Hope this is clear enough. Thanks in advance.