Pedro Janssen
pedro at plex.nl
Wed Jan 20 02:16:28 CST 2010
is there some-one who can explain me the error, and why do i get it, when the query is working correct? See query below Pedro ----- Original Message ----- From: "Pedro Janssen" <pedro at plex.nl> To: "AccessD" <AccessD at databaseadvisors.com> Sent: Monday, January 18, 2010 2:42 PM Subject: [AccessD] query error > 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 > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >