Handling Repeated/Mirror Records in a Query as a result of One to Many Relationship

[Bkper087]

I have built a contacts manager based on an Outlook export (I know I can link the two programs, but I wanted to customize the contacts a bit further). I built the database in a way that phone numbers, addresses, etc. allow for multiple entries for each person under the same column using a foreign key. The only difference is a field called "Type" which designates the entry for Home, Work, etc. The issue I ran into is when I queried the data I get multiple entries for the same record. As you are all likely aware, Access repeats the data in a query for each different case. For example if Bob Jones has a personal and work phone number, Access will show the results in a query like this:

1. Bob Jones 555-555-5555 Personal


1. Bob Jones 555-222-2222 Work
2. Jerry Smith 555-111-1111 Personal

If I kept the data in Access it wouldn't necessarily be an issue. However, I want to be able to export the data in an excel file. How do I get Excel to return the data so it looks like this:

1. Bob Jones 555-555-5555 Personal 555-222-2222 Work
2. Jerry Smith 555-111-1111 Personal

[ItsMe]

I would probably start with a Report Object and use grouping to get, at least close to, what you want. Then, export the report as an Excel file.

[June7]

Also review http://allenbrowne.com/func-concat.html

[Bkper087]

June7 I used the link you posted. Its not exactly what I had in mind, but it will work just fine. Thanks!