J
Jake
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
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