Syntax error in INSERT INTO statement in MS access?

Question

My professor asked me to insert the following record on tbl Patients using SQL statement... I followed the syntax in http://www.w3schools.com/sql/sql_insert.asp but it always says Syntax error in INSERT INTO statement in MS access when I run it ... I create tbl Admissions,tblDiagnostics and tblPatient ... now since she told me to insert a record in Patients table I do these step "I go to query design i chose tbl Patients and then right click and I chose SQL view and then I typed this in ....
INSERT INTO Hospital Record (PatNo,fName,lName,BirthDate,Address,City,State,Zip)
VALUES (15,'Juan','Dela Cruz','5/6/1998','San Jose','TN',92812);

*please help me find my error :(

Answer 1

Try this

INSERT INTO tblPatient(PatNo,fName,lName,BirthDate,Address,Cit…

VALUES (15,'Juan','Dela Cruz','5/6/1998','San Jose','TN',92812);

Answer 2

Assuming BirthDate is defined as a DATE type, your date value needs to be compatible. IIRC, in Access this would be by enclosing the string in hashtags like this: '#5/6/1998#'

Answer 3

To Solve this kind of Problem you should provide the whole structure of the Table and Error can also come because you may have a column with datatype as int and you are going to insert character or something similar to this...

Answer 4

Ms Access Insert Into Statement