MS Acces and VB.Pleeese Help

[kruks]

Hi everybody,
I have this line of code but
I get a syntax error (missing operator)in query expression

Can somebody please tell me what I am doing wrong

rs.Open "SELECT * FROM SupAct where InDate < " & Now() & ";"
Thanx

[hayessj]

I think dates have to be enclosed by # in Access
i.e.

rs.Open "SELECT * FROM SupAct where InDate < #" & Now() & "#;"

[kruks]

Thank you so much it works great