Moving record from one table to another

[durdle]

Hey,

Just wondering if anyone can explain to me how I can write code, to MOVE a record from one table(tblmain) and put that into another table(tbltemp).

Thanks
Chris
________
volcano classic

 

[Rob.Mills]

If the structure is the same for both tables you can run an append query and then a delete query.