Duplicate many records with auto save

J

jehad hindi

Dear all
I have Microsoft Access application and the DataBase
(SQL) so i have function that i want to Duplicate many records through
( Append Query ) BUT i have one problem that i have Gernrated number so when
i run the Append Query i got error
 
B

Brendan Reynolds

jehad hindi said:
Dear all
I have Microsoft Access application and the DataBase
(SQL) so i have function that i want to Duplicate many records through
( Append Query ) BUT i have one problem that i have Gernrated number so
when
i run the Append Query i got error
Click to expand...


You need to specify the columns to be appended and make sure you do not
include the generated column. For example, if your existing query looks
something like this ...

INSERT INTO TargetTable
SELECT *
FROM SourceTable

.... then you need to change it to something like this ..

INSERT INTO TargetTable
(SomeColumn, SomeOtherColumn)
SELECT SomeColumn, SomeOtherColumn
FROM SourceTable
 
Top