combining records with some identical fields

[Guest]

I must work on a database that has some records with the same values in the
first fields. [ For example, 12 records have 'john doe' in the first field, 1
has 'mary smith', 3 have 'jane doe'.]

The second fields (street names) all have different values. [Each name is
associated with a different street name. So, 'john doe' has lived on 12
different streets and 'jane doe' has lived on 3 different streets and 'mary
smith' has lived on only one street.]

I want to eventually show the person's name and all the streets they lived
on, in a report. How do I automatically associate the names (first field)
with the multiple values that can exist in the second field? Do I create a
table for each person's name ..that includes all streets? How do I automate
this?

 

[Van T. Dinh]

(See reply in "microsoft.public.access")

Are you sure you posted enough messages for the same question?

See http://www.mvps.org/access/netiquette.htm