Guys

I have one table that contains a memo field (tblWithMemoField)
The second table has some keywords (tblWithKeyWords)

What I want to do is a query that can generate a table using the field fldCriteria(tblWithKeyWords) to find the records from the tblWithMemoField on field (fldMemo).
There is no relationship between the tables.


tblWithMemoField
ID Remarks
CompanyName
fldMemo This field will be the target - Memo







tblWithKeyWords
idKeyWord
fldCriteria My criteria - Text field






Would be something literally like below - Of course the statement below doesn't work.

Code:
SELECT CompanyName FROM tblWithMemoField WHERE(((fldMemo)LIKE"*"+[tblWithKeyWords]![fldCriteria]+"*"));
How can I do it?

Luthius