Unknown syntax error

[Toby]

Can anyone tell me why this statment returns a syntax error?

UPDATE courseDate SET sdate=#11/9/2004 9:00:00 AM#, tdate=#11/10/2004
3:00:00 PM#, WHERE dateID=175

A link to an online sql reference specific to ms access would also be
appreciated.

Thanks

 

[Van T. Dinh]

Can't see what's wrong with your SQL (assuming you are using JET back-end)
but try:

UPDATE courseDate
SET sdate = #11/09/2004 09:00:00#, tdate=#11/10/2004 15:00:00# WHERE
dateID=175

Check the Microsoft JET SQL Reference "book" in Access Help.