M
massa
I have two tables one is 1/31/2008 and the other is 3/31/2008.
They each have two fields : a document id number and usd amount.Some of the
doc id numbers will be identical, some will not. I need to update the 1/31
table with the 3/31/ 2008 usd amounts. I dragged the two tables onto the
query builder, created a join with the doc id numbers, changed it to update
query; in the field for usd amount in table 1/31 , in the update to row I put
[1-31-2008].[Amount]
This would be correct if it included the 0.00 dollar amounts as well. Can
someone help with this?"
They each have two fields : a document id number and usd amount.Some of the
doc id numbers will be identical, some will not. I need to update the 1/31
table with the 3/31/ 2008 usd amounts. I dragged the two tables onto the
query builder, created a join with the doc id numbers, changed it to update
query; in the field for usd amount in table 1/31 , in the update to row I put
[1-31-2008].[Amount]
This would be correct if it included the 0.00 dollar amounts as well. Can
someone help with this?"