Answer the question
In order to leave comments, you need to log in
How to create a query in Access to add n records?
I need to create a query that will add 10 records to a previously created table. But there are exceptions.
If you write like this, it says that a semicolon is missing.
INSERT INTO [Изделие] ( [название], [вес], [количество], [цена], [дата_изготовления], [фирма_изготовитель] )
VALUES
('Название1', 1.1, 1, 1.1, #2001/01/01#, 'фирма1'),
('Название2', 2.2, 2, 2.2, #2002/02/02#, 'фирма2');
INSERT INTO [Изделие] (
[название], [вес], [количество], [цена], [дата_изготовления], [фирма_изготовитель]
) VALUES (
'Название1', 1.1, 1, 1.1, #2001/01/01#, 'фирма1'
);
INSERT INTO [Изделие] (
[название], [вес], [количество], [цена], [дата_изготовления], [фирма_изготовитель]
) VALUES (
'Название2', 2.2, 2, 2.2, #2002/02/02#, 'фирма2'
);
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question