Global Modify

[Jacob-Bushnell]

I sent some of my data to a data processing company that updated all my address (14,200) using the National Change Of Address Data base. The data I sent is (The Unique ID #, FIRST NAME, LAST NAME, CITY, STATE, ZIP.)

The data I got back is all the above plus new address, city, etc. for Some of the records (those with new addresses)

So now I need to update the existing data in the Address, City, State and Zip fields using this new data.

First I want to globaly modify the table that was returned to me, keeping the same Unique ID #s.

Second I want to Merge this updated data back into my main data base.

As you can tell by my question. I will need you to keep it simple.


Thanks,

Tom

 

[Fuga]

Can´t you use update queries?

Fuga.

 

[Jacob-Bushnell]

Duh-Huh! Thank you, Fuga. I am not very good at databases yet! In fact, I've got a LOONG row to hoe!
Thanks a lot