Hi Folks,
My access records containing many words. I want to design a query that can search for the records and return whose contain exactly matched word(s). I tried the like statement, but it is not successful. Here is an exmaple: My record containing texts like < Purchasing Manager>; <retired Eventmanager>. If I used like "Manager" in query criteria, it does not return any record. If I used like "*Manager", it returned all records containing Manager, as well as other records that containing word like Eventmanager (which is not the record I look for). Are there any way I can have query that return records containing only exactly matched word(s)?
Peter