I have two tables. Access 2007
1. KEYWORDS has one field named KWDescription with values (orange, apple, mango, tomato)
2. STATISTICSTABLE5 has several fieds that some of which I would like to display. One of the fields is called Title. Fields in Title have values like.
This is an apple.
I sold a Mango.
I ate a tomato.
i.e some values in Title have some content from KWDescription
I would like to use a query to select all rows in STATISTICSTABLE5 for each row that has a keyword(KWDescription) found is found in the Title.
STATISTICSTABLE5.Title KEYWORDS.KWDescription Count of Keyword
This is an apple. Apple 1
I sold a Mango and Orange Mango, Orange 2
I ate a tomato Tomato 1
I have tried this but am not getting any meaningful results
Any help is appreciated.
SELECT Exists (Select * from Keywords where Keywords.KWDescription = StatisticsTable5.Title) AS Expr1, StatisticsTable5.Title
WHERE (((Exists (Select * from Keywords where Keywords.KWDescription = StatisticsTable5.Title))<>False))