hello,
I'm looking for a way to search a memo field in MS Access
by (multiple) keywords. does anyone know how this done or
where i might find a tutorial on this subject?
thanks for your time in advance,
tom
The simple answer is that you can use criteria such as
WHERE Memofield LIKE "* Oats *" AND Memofield LIKE "* Peas *" AND
Memofield LIKE "* beans *"
to get the old nursery rhyme. If need be you can write VBA code to
take user input such as
"Oats, peas, beans, and barley"
and use it to construct a search like that above.
The longer answer is that if you want true text searching, with
automatic expansion of plurals and verb forms (i.e. searching for
"mouse" finds "mice", for "send" finds "sent"); searching for a word
within n words of another word; words in the same sentence; all the
nice features - you need a tool other than Access. There are good
"textbases" available, but I've been out of that market for so long
that I no longer know which are the mainstays these days.
