Combining Duplicate Record Information

[Stacy]

Hi All,
I have a small issue, I am hoping someoe can help me out with.
I am bringing in an Excel document that has the following two fields:

Name Address

The issue I am having is I have the same names appear multiple times
at different addresses... I need to make this one record, but keep a
"comments" type field to house ALL listed addresses.

so, what I need is:

Name1 123 Street
Name1 456 Street
Name1 789 Street
Name2 123 Street

to end up something like this:

Name Address Comments
Name1 123 Street 123 Street, 456 Street, 789 Street
Name2 123 Street


Is there a way to do this?

Thanks for any help....
Stacy

 

[Anne]

I have had to work with a lot with existing data imported from excel and it
never comes over the way you want.
I would split this into 2 tables.
For the first table use only the name field, but add an autonumber NameID to
that table. ( when you import or copy and paste your excel table, be sure
that the first column in excel is empty, so that there is room to for the
autonumber field).
Create a second table with the fields for name and address and import Name
and address.

If the excel data will be updated only in access after the initial import, I
would use an update query to add the ID field to the address table.
If it will be a constant new import, you can just create a relationship
between the two tables through a query using the name field.
Than through a query you can form the relationship between the two tables
(either by Name ID or NameField) and with a form, you can link the 2 tables
and have the name show on a main form and the various addresses an a
subform.

Anne

 

[Stacy]

Anne,

Thank you so much for your help. That seems to work awsome in Access
as long as I am setting it up on a form and subform, but now I have to
somehow create a table (to export to Excel) that has Name, Address
(First listed) and Comments (which houses all other addresses that may
be listed). The addresses vary, I might have 1 on one person but 3 on
another.

Is there even a way to combine all addresses into one field?

Thanks for any comments or suggestions.
Stacy