Hi All,

Here is my sql select query.

if i am checking one condition i'm not getting any problems.
Please Login or Register  to view this content.
If i am providing multiple conditions,I'm having problems.

Please Login or Register  to view this content.
If i check with this data in sql,the query gave me result.

I think that i am following the correct syntax to write a sql query with multiple where conditions in excel vba.
If not please let me know the correct syntax.

Please let me know the problem why it happening?

Regards
Kumar

---------- Post added at 03:32 PM ---------- Previous post was at 03:20 PM ----------

Hi,

I found the why the query is creating the problem.
This is because of syntax error.

This is the query that i have rewrite.Now it works.
Please Login or Register  to view this content.
Regards
Kumar