SELECT *
FROM [rating & px Tgt History]
WHERE ((([from] Like "*Init*" And [action] Like "*Target*")=False and deleted=false));
but when the access linked to backend is sql server via odbc i get this
ODBC call failed
{microsoft][odbc sql server driver][sql server]line 1:incorrect syntax near '=' #170
One thing that jumps out at me is the asterisk * needs to be a %... ex: Like '%Init%' ... the only other thing that looks wrong is you are using double quotes.. try using single quotes.
