filter recordset parameters not effective 1

[shopwise]

WHERE Not IsNull(CustomText10) AND Not IsEmpty(CustomText10)


When using the above code in my recorset to eliminate any records where CustomText10 does not contain any value, I am not being successful. The records that contain no value are nevertheless being displayed.


I also tried adding:


AND CustomText10 <> ""


Apparently this latter code is not in the correct syntax as it is giving expected end of statement error message.

 

[PHV]

What about this ?

WHERE Trim(CustomText10 & "")<>""

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[shopwise]

Thanks for your response but when I did as suggested:

AND (CustomText10 & "")<>""

The error reads:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression ... AND (CustomText10 & [)<>] ...

so
AND (CustomText10 & "")<>""
is being rendered as:
AND (CustomText10 & [)<>]

 

[PHV]

Please, reread CAREFULLY my suggestion.

 

[shopwise]

I didn't realize that Trim was a function, I thought you were indicating that you have trimmed some code. In any case, I have tried:

...AND Trim(CustomText10 & "")<>"".. but the same error occurs:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'CustomText10 <> 'N/A' AND Not IsNull(CustomText10) AND Not IsEmpty(CustomText10) AND Trim(CustomText10 & [)<>]

 

[PHV]

Any chance you could post the code building the SQL ?
My guess is to use this:

WHERE CustomText10<>'N/A' AND Trim(CustomText10 & '')<>''

With the above you don't need the IsNull and IsEmpty stuff.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886