I have a MS Access 2010 database linked to Practicemaster (Tabs3) legal case management system using FairCom c-treeACE ODBC - 32-bit version. I use the Access database for queries and reports. When I upgraded from Version 17 to 18 of PracticeMaster (and the ensuing ODBC driver), the software no longer supports using the LIKE operator on a MEMO field (NOTE field in their world). This has been confirmed by the vendor and I need to find an alternate method of filtering my records. Without knowing much about Access, they are suggesting the CONTAINS or IN operator/function.
I don't see that Access has CONTAINS and the IN operator doesn't fit my needs.
This is the LIKE clause I am using on a MEMO field in a query. I'm looking for a particular string of characters anywhere in the field.
Like "*" & "police" & "*"
What are my options? Is there another alternative to crafting the query to achieve the results I'm looking for?
Any guidance or assistance is very much appreciated.
Thank you.
I don't see that Access has CONTAINS and the IN operator doesn't fit my needs.
This is the LIKE clause I am using on a MEMO field in a query. I'm looking for a particular string of characters anywhere in the field.
Like "*" & "police" & "*"
What are my options? Is there another alternative to crafting the query to achieve the results I'm looking for?
Any guidance or assistance is very much appreciated.
Thank you.