copy data from one record to another

[roberta]

Not really sure what your getting at. But to copy one
record to another, you can use an append query(1) or an
update query(2), dependant if you want to add a record(1),
or copy a record to another record(2).