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!
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: