SQL Query in Access ODBC Call failed

[nflutter]

I`m trying to write a query in access using the query builder but I am getting an ODBC error message when I try to run it. The SQL behind the query is:

SELECT AUDIT_HEADER.ACCOUNT_REF, AUDIT_HEADER.DETAILS
FROM AUDIT_HEADER
WHERE (((AUDIT_HEADER.DETAILS) Not Like "*deleted*"));

I can run all other types of queries to the same DB and they work fine, the problem is when I try to run a 'Not Like' filter. Am I writing the query correctly?

 

[cheerio]

Try replacing * with %

Try replacing " with '

 

[nflutter]

Thanks for quick response. Tried all variations but with no joy. I have made a new query just using NOT and I get the same problem, the SQL is:

SELECT AUDIT_HEADER.ACCOUNT_REF, AUDIT_HEADER.DETAILS
FROM AUDIT_HEADER
WHERE ((Not (AUDIT_HEADER.DETAILS)='deleted'));

I cant see anything wrong with this but it still returns ODBC call failed. If I do the same statement with = instead of NOT it works fine, the error only occurs when I use the NOT statement. Maybe the ODBC driver is the problem?
Any comments appreciated.

 

[Golom]

And this?

SELECT ACCOUNT_REF, DETAILS

FROM AUDIT_HEADER

WHERE DETAILS <> 'deleted'

 

[nflutter]

Still the same error message, I entered <> "deleted" into the Access query builder and also copy & pasted the satement you supplied int the SQL view but both returned the error. I am starting to think the ODBC driver for my DB just wont accept a not statement, weird though it sounds.

 

[Golom]

Possible I suppose. Try a work-around

SELECT ACCOUNT_REF, DETAILS

FROM AUDIT_HEADER

WHERE DETAILS < 'deleted' OR DETAILS > 'deleted'

 

[nflutter]

Half way there!, this works great if I want to exclude entries with only the word 'deleted' but my original statement was NOT LIKE, the workaround cant filter these entries.
Thanks for your help