MS Access SQL helped needed for SQL beginner..
Can someone tell me what is wrong with the following code please?
Im trying to insert 3 rows of data into table STAFF in Access 2003 and keep getting an error saying "Charectors found at the of SQL statement"
INSERT INTO STAFF
VALUES ('C01', 'Steve', 'Zion', 'Worcester', 'WR25PF', 1, 'T01');
VALUES ('C02', 'John', 'Scarry', 'Worcester', 'WR25PF', 3, 'T01');
VALUES ('C03', 'Paul', 'Andrews', 'Worcester', 'WR25PF', 7, 'T01');
Any help will be greatly appreciated!!
__________________
Previously:
BRCA Micro Section Chairman.
BRCA Micro National Champion.
Currently:
JQ fan.
Bellend.
Forums are better than Facebook groups 
|