View Full Version : Searching Memo Fields


bbrant
01-09-2002, 09:56 AM
I created a query-by-form that searches my table fine. But what I want to do is to enable users to search for multiple "keywords" at a time from a memo field. Right now I can only search for one word at a time.

Any thoughts or suggestions how this could be accomplished?

Thanks,
Brian

Jack Cowley
01-09-2002, 02:11 PM
I would suggest that the user enter the words separated by commas. Then in a loop take apart the string and using code similar to that in MS Knowledge Base article Q210242 build a Where clause using the Or and Like operators. The Where clause would be built inside of the loop that separates the words.