[AccessD] query error

Hi Pedro

It could be some fields with Null. Or the InStr variables. Try with:
  
  ((InStr(1,[BVO].[3],[BVO].[Bnummer]))<>0));

/gustav


>>> pedro at plex.nl 20-01-2010 09:16 >>>
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