How do I append records to a different table?

F

Frank Martin

My accountant wants me to add records from
the creditors "tblSuppTxns" to the ledger
"tblLedgerTxns".

My problem is to add only select fields of a
record from "tblSuppTxns" to only select
fields of "tblLedgerTxns".

Can someone give me a clue on how to start
this? Do I use a macro?

Please help.
 
Top