Copy data

[tspies85 via AccessMonster.com]

How can i copy or save data to another table?(it's just like duplicating the
same record into a new table).Hope to use vb code to do it in form...tq

 

[J. Goddard]

Hi -

If the structure of the two tables is the same, including the field
names, you can use SQL :

Insert into table2 select * from table1 where ... conditions.

If the structure or field names are not the same, use:

Insert into table2 (field1, field2,...) Select table1.field1,
table1.field2,... from table1 where .. conditions.

MS Access help on INSERT INTO gives a good explanation, with examples.

John