How do I append records to a different table?

  • Thread starter Thread starter Frank Martin
  • Start date Start date
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.
 
Check out append queries in Help file. They are used to copy data from one
table to another.
 
Thank you. I have the append queries
working, but in this case I get an error
about 'type' conflicts, because the type in
the destination table is "number" and that of
the sending table is "text".

I cannot change the 'type' in the destination
table because of relationship constraints,
therefore I need to know how to send the
"text" data across and have in convert to
"number" in transit.

The relevant field in the destination table
is a Combo box; will this have an adverse
effect?

Please help,


"Ken Snell (MVP)"
message
 
Sounds like you're being bit by the "lookup field" problem. The combo box
that you see in the table is displaying a lookup value to you, but is
actually storing the real value in the table. Usually, the real value is a
number (an ID of some type, and it's usually a Long Integer), while the
displayed value is a text string "description" of what the ID number
represents.

Your append query must provide the ID value, not the description value, to
the table.
--

Ken Snell
<MS ACCESS MVP>
 
Back
Top