Hi! I'm having a hard time copying some of the record from one table to another. I have 2 tables in access and they are almost the same except that table2 doesn't have some of table1's field. I want to copy from table1 those data needed to fill table2 but I don't know how to copy partially. I mean if I use . addnew it automatically copies the whole record right?? I only need some so how do I do that? Please help me asap. I need it for my project... Thanks a lot!

Output of both tables are shown on 2 datagrids..

Here a SQL statement that will copy some of the fields from Table 2 to Table 1

INSERT INTO "table1" ("column1", "column2", ...)
SELECT "column3", "column4", ...
FROM "table2"

This will do the job for you.