[AccessD] using Like with ODBC

Robin Lawrence lawrence.robinr at gmail.com
Tue May 10 12:51:33 CDT 2011


Hi All

I'm connecting to a Sage Line 50 Accounts program via ODBC and need to do a 
multiple LIKE selection from Access XP

ie in the query criteria
[Status]
LIKE "*sold*" OR LIKE "*returned*" OR LIKE "*finished*"'  but am getting a 
syntax error from the ODBC driver


Been a while since I've had to do this - can't remember the workaround, any 
help greatly appreciated.....
TIA

Robin Lawrence




More information about the AccessD mailing list