Hi everyone ,

I would like to insert 2 records into my table toys that is composed of 4 items : ToyID , ToyName , Price , Description
My querry is this one

INSERT INTO Toys (ToyID, ToyName, Price, Description)
VALUES (1, 'ToyTrain1', 11.00, 'Red/blue battery powered train');
INSERT INTO Toys (ToyID, ToyName, Price, Description)
VALUES (2, 'ToyTrain2', 11.00, 'Green/red/blue battery powered
train');

the error message that i am having is , character found after end of SQL statement
What should I do ?
Thank you in advance

In Access that is 2 different queries. You'll have to run them separately.

Thank You For Your Answer

Did it help? Do you need further assistance?