I am sending off an address list to a service to check the list. I do not want to send them all the fields in my list since they are only verifying the addresses that are correct. So I query my list to show only Names and Addresses, not account numbers ETC ETC. I get the list of only the good names back. I want to take those names and merge the those entries back into the Address list with the other account info and such so I can only send out the addresses we have that are correct. I know I can find duplicates and merge data but how do I merge specific fields with the data I have. I am currently using account numbers as a primary key, should I just auto-number, make that the key and somehow use the key to sort the whole thing out adding a field “updated” so in the address list all the duplicate keys are positively updated…
I hope this makes sense. Thanks for all your posts and help to get me to this level of access work!
Dino
