[AccessD] query error

Pedro Janssen pedro at plex.nl
Mon Jan 18 07:42:00 CST 2010


Hello List,

i get an query error:
Query syntax error: One query component isn't complete.

but when i click ok, the query still is working good.

Why do i get this error?

SELECT [BVO].[Bnummer], [BVO].[papL], [BVO].[1], [BVO].[2], [BVO].[3], [BVO].[4], [BVO].[5], [BVO].[6], [BVO].[7]
FROM BVO
WHERE ((([BVO].[Bnummer]) Like "B08-0*") And (([BVO].[papL])="1") And ((InStr(1,[3],[Bnummer]))<>0));

Best Wishes

Pedro


More information about the AccessD mailing list