Update Data in one table based on matching field in another table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 2 tables that both include ID numbers. Table 1 has payment data for
each record, which I would like to add to table 2, but the data being updated
in table 2 needs to match by ID number. example:

table 1
ID Payment
G67 45.00
F56 55.00

table 2
ID CltName Payment
G67 Joe would like this to be 45.00
F56 Jane would like this to be 55.00

I do not need to do this with a Payment field already in table 2. It could
be a query which I then make into a new table. I am just having trouble
getting the matching info to transfer. I have tried dlookup with no luck.

thanks
 
You should not be storing the payment value in two separate tables. Just
retreive it from table 1 when you need it.
 
This data is fake. I used this simple example because if someone can tell me
how to do this (instead of some random comment on where I should be storing
data), then that will show me what I need to do in my actual database.
 
The word to the wise still holds true, the only time you want to store
"redundant" data is in a transaction type table
ie "what was the cost of the item on this invoice at he time it was
invoiced"

Pieter
 
Once again, why would a person take the time to write something irrelevant??
This is not my real data or scenario, but if someone can tell me how to do
this I will be able to do what I need to do. If someone could attempt to
actually help with my question it would be greatly appreciated. I have tried
to make it very simple.

-Jake
 
Back
Top