[RESOLVED] syntax error

[samer22]

Hello
I'm getting a syntax error with this query.

RS.Open "select * from Tbl1" & _
" WHERE Date_Rend <> '" & "" & _
"and (Date_Rend <> #" & Format(Date, "mm/dd/yyyy") & "#)", DB, adOpenStatic, adLockOptimistic

Would you please correct me
thanks a lot

[LaVolpe]

That 2nd line of your query looks odd. Try printing out you query to the debug/immediate window and look at it. Does it look right?

[samer22]

Thanks sir
this is the output

select * from Tbl1 WHERE Date_Rend <> 'and (Date_Rend <> #01/19/2018#)

[LaVolpe]

Hmm, you do see the problem with that query don't you?

[samer22]

Hmm, you do see the problem with that query don't you?

I tried a lot but I get error with data type or syntax error

[samer22]

solved

WHERE Date_Rend Not Is Null