Hello,
I just ran into this and narrowed it down to TRIM. Without the TRIM(),
it works fine.
In MS Access,
SELECT DISTINCT [Name] FROM [Customer Information] WHERE [Name] IS NOT
NULL AND LEN(TRIM([Name])) > 1 ORDER BY [Name] ASC;
becomes
SELECT DISTINCT "public"."Orders"."Name" FROM ("public"."Orders" LEFT
OUTER JOIN "public"."POs" ON ("public"."Orders"."OnlineCode" =
"public"."POs"."OnlineCode" ) ) WHERE (NOT(("public"."Orders"."Name" IS
NULL ) ) AND (char_length(ltrim(rtrim("public"."Orders"."Name" )))))> 1
) ) ORDER BY "public"."Orders"."Name"
As you can see, there is an extra right parenthesis. (Customer
Information is an Access query onto Orders, in case the name change is
confusing from my test example.)
Thanks!
James