Copy record from 1 table to another

[Anthony George]

Hi Everyone

I wonder if anyone can help me with code that i can use to copy a single record from table1 to table2

that i can use in a subroutine.

Thanks in advance to anyone that may offer some help

Kindest regards

Tony

 

[FoFa]

Use an APPEND query based off a primary key or something to select the row/s you want.