Search results

Thanks. This works perfectly for one of my fields. Unfortunately the other field I would like to search in is a memo field and it appears you can't join on a memo. I realise this is probably for performance issues but the data I am searching each day is only around 500 records so wondered if...

Perfect Galaxiom. Have it working just how I want with a minor tweak to pick up words that have a full stop or other non-alpha character after them. Thanks for your help would have taken me ages to figure it out otherwise!

Thanks Galaxiom, Please bear with me as I am completely new to Access as of two days ago! I have created your query above and it is bringing back what I would expect without the regular expressions e.g I have ole in my keyword search and I only want ole as a whole word not pole for instance...

Hi, I am trying to perform some keyword searches of a text field. My preferred option would be to hold all the keywords in a separate table and then use something like SELECT * FROM Text Table, Keywords Table WHERE (((InStr[Text Table].[Text],[Keywords Table].[keywords])) > 0 )); This works...