A simple solution to the problem
I get round the fact that the Sage ODBC driver does not like the "Not Like" or not equal "<>" expressions, by using the IIF statement to turn the text string into a number. e.g. if I want to create a query that excludes all Sales Ledger accounts that have...