Is there code to get parts of a table and put them into another table?

[nicmar]

Hello,
I am trying to write the code to copy part of a table if certain requirements are made. I want to copy part of a table and put it into another table, but I can not figure out the code. I do not want to manually do it. Does this make any since?? What I am working on is a very in-depth project so it is difficult to explain everything. If anyone know if this is possible I would greatly appreciate a reply.

Thank you,
nicmar

 

[dhookom]

It is fairly simple to create an append query that will select a group of records and fields to append to another table. You can use an update query to update existing records.

Duane
MS Access MVP