[AccessD] Paradigm for Keywords in a database

How about?  

strSQL = "SELECT * FROM tbl1 WHERE (('tbl1!Title LIKE *' & Chr(34) & 
search1 & Chr(34) & '*')
        OR ('tbl1!Keyword LIKE *' & Chr(34) & search1 & Chr(34) & '*'));


Eoin C. Bairéad wrote:

>Hi
>
>I have a database where each record has a number of Keywords assocciated
>with it. I can't for the life of me see how to construct either  the table
>or a query to find, say, all records where the keywords "Access" Developers"
>and "brilliant" can be found.
>
>Any ideas ????
>
>Eoin
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada