Consolidating multiple records into one record

Joined
Nov 29, 2012
Messages
1
Reaction score
0
Hi,

In Access 2010, I have a table with two fields. The first field (Investor Name) contains several occurrences of the same text (i.e. Investor A occurs 2 times, Investor B occurs 3 times, etc.). The second field (Investment) may or may not contain duplicates (i.e. more than one Investor may have invested in the same Investment). I'm trying to create a query that will show me, in one record, all the Investments that each Investor has made.

So for the following data:
Investor A Investment 1
Investor A Investment 2
Investor B Investment 1
Investor B Investment 3
Investor B Investment 4

I want the query to report back the following:
Investor A Investment 1 Investment 2
Investor B Investment 1 Investment 3 Investment 4

To clarify further, I'm NOT looking to concatenate the results into one field. Instead, I want each Investment to appear in its own field, so that I can pull each one into a report later. Ideally, there should be no limit to the number of Investments that each Investor has made, although practically speaking, it likely won't exceed 10 or so.

Is this possible? Any suggestions? I really appreciate any help in advance!
 
Last edited:

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

Top