Find Partial Text match in MS Access Query
Posted on 2009-05-06
I have a query by form function that calls a report. The form is pretty straightforward...about a dozen drop-downs with static possibilities. The form is connected to a query that uses the following formula to handle all the query possibilities:
The query is the basis for a report.
Everything works great, but I would also like to search a "notes" field by keyword. The notes fields, as you might imagine, are paragraphs full of info. I would like to be able to search the notes field by a single word or partial word, so that a search on "dog" would find "dogma" and "dogs" (and to be clear, search for the text anywhere in the notes field, even in the middle of a word). How can I do this using the above formula? Where do I put the "like" or "*" or whatever I 'm guessing I will need? The name of the field is "Notes" BTW.