I have trouble duplicating rows from a MS Access table. This is a table I have. My (PK) in this table are BID, Order_nr, Parameter_ID and TimeStamp.
This is a query I have now, but it doesnt work; says "INSERT INTO syntax error"
INSERT INTO Measurement_test ( BID, Order_nr, Parameter_ID, Value, Machine_Serial_nr, TimeStamp, Passed)
SELECT BID, '12345', Parameter_ID, Value, Machine_Serial_nr, TimeStamp, Passed
FROM Measurement_test
WHERE BID = 123;
I want to copy all those rows and create new rows while setting the Order_nr to 12345. How can I accomplish this?