Unknown syntax error

  • Thread starter Thread starter Toby
  • Start date Start date
T

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
 
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.
 
Back
Top