I am trying the following query in MS-Access 2007, but it fails on the time field.
INSERT INTO LOG ( EMPLOYEECODE, STATUSID, LOCATIONID, TIME, DURATION, SHIFTID, LATECOMING, EARLYGOING, LOGDATE, STATIONID ) VALUES ( 1, 1, 0, '4/21/2009 2:25:53 PM', 0, 8, 0, 1, '1/1/2009', 1 )
TIME field is defined as a datetime.
TIME field, the query works fine!
I've tried a number of different things, such as enclosing the datetime in hashes, quotes etc. However, the query still fails on the time field.
Thank you guys! That almost got me fully there. I still kept getting the syntax error for the insert statement, but then on further googling, I realized that
TIME might be a reserved keyword, so putting it on box brackets as