Duplicate Record Information

S

Stacy

Hi All,

I am not even sure this can be done, but here goes....

I have a table that has duplicate record information with the
exception of one field (address).

example:

Record 1 Name1 Address1
Record 2 Name1 Address2
Record 3 Name2 Address1

I need to somehow get Address2 to the comments field of Record 1, for
each record that Name is duplicated.

So that when it's complete, it should look like this

NAME ADDRESS COMMENTS
Name1 Address1 Address2
Name2 Address1


Is there a way to do this through either a query or using Visual
Basic?

I would appreciate any help...
Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mailing address block: sorting 1 row to columns 1
Change vertical data into horizintal table 1
looking for logic guidance 1
Publisher 07 Mail Merge 1
Merging from an Excel file with graphics 1
Populate a field from a Secondary Data Connection from a query valueof a dropdown list 3
Fill a word form clicking on an excel cell 1
.LST File 1

Top