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
Printable View
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
I think dates have to be enclosed by # in Access
i.e.
rs.Open "SELECT * FROM SupAct where InDate < #" & Now() & "#;"
Thank you so much it works great