Exclude keywords from query 2007

[agibsonsw]

Hello. Access 2007.
I have a list of keywords in a table which I wish to exclude from a query result for a particular column.
I can use the expression "Not In(SELECT Excluded FROM tblKeywords)" which works. But how can I exclude the words if they appear anywhere within the column text?
That is, I want to match anywhere within the column.
Thanks, Andy.

[HansV]

Try this:

SELECT * FROM MyTable WHERE ID Not In (SELECT ID FROM MyTable, tblKeywords WHERE ParticularColumn Like "*" & [Excluded] & "*")

MyTable = name of your table
ID = primary key of your table
ParticularColumn: field in which you're looking for the keywords.

[agibsonsw]

That works great. Thanks, Andy.