Hello all. Just looking for some guidance with a query. I have one query that finds a keyword in a string based on keywords in a table.
Then my next query will use the first query and display the keyword based on the query results. The string can be any length and there isn’t a naming convention.
I’m trying to find a way to search for multiple keywords in the string and then concatenate the results within a column. Any and all help will be very appreciated.
Code:
SELECT
excelRaw.rawIncdNum, excelRaw.rawFileName, excelRaw.rawSynopsis, tblClass.class_keyword, tblClass.class_value, InStr(1,[excelRaw].[rawSynopsis],[tblClass].[class_keyword]) AS Expr1
FROM excelRaw, tblClass
WHERE (((InStr(1,[excelRaw].[rawSynopsis],[tblClass].[class_keyword]))>0));
Then my next query will use the first query and display the keyword based on the query results. The string can be any length and there isn’t a naming convention.
Code:
SELECT
excelRaw.rawIncdNum, excelRaw.rawFileName, excelRaw.rawSynopsis, qryClassInStr.class_keyword, qryClassInStr.class_value, excelRaw.rawClassRoll
FROM excelRaw LEFT JOIN qryClassInStr ON excelRaw.rawIncdNum = qryClassInStr.rawIncdNum
ORDER BY excelRaw.rawClassRoll;
I’m trying to find a way to search for multiple keywords in the string and then concatenate the results within a column. Any and all help will be very appreciated.