RE: Having Trouble Searching Memo Field, charlee, 05-11-2006
Try this for troubleshooting SQL...
by Roger Harris, May 18, 2006 12:41
Access allows a LIKE operator on memo fields (not all ODBC databases do), so that should work (without the double-quotes, as Dave pointed out). But maybe you are really executing the statement you think you are, or maybe an ODBC error is being returned. After the statement, add a line of HTML that just prints out $sql_statement$ to see the executed SQL with all variables resolved, and $sql_error$ to see any ODBC errors returned.
Name E-mail optional TopicMessage:
HTTP Link: Link text: