Access keywords

[tom]

hello,
I'm looking for a way to search a memo field in MS Access
by (multiple) keywords. does anyone know how this is done
or where i might find a tutorial on this subject?

thanks for your time in advance,

tom

 

[Douglas J. Steele]

The simplest approach is simply to use LIKE "*keyword*" repeatedly for each
keyword of interest.

A more robust approach is to create a table of keywords, and an intersection
table to resolve the many-to-many relationship between your keyword table
and the table that contains your memo field. As you populate the memo field,
you insert rows into that intersection table. That should make retrieval
quicker (although it does make updating the data more complicated).