Code:
INSERT INTO tblDiary ( Year, Month, Day, Time, Event, Venue,
Details) 
VALUES('1976','12','03','10pm','strEvent','strVenue','strDetails')
why is this giving a syntax error please?
PS all fields are text fields, field names have been checked. These are not variables, 'cos I wanted to check the SQL...

Ta