maincomputer
New member
- Local time
- Today, 21:49
- Joined
- Jun 22, 2012
- Messages
- 9
Hi
I have a table of results I need to query. It is badly designed. It holds test results for individuals, where there can be a variable permutation of results.
Like this:
Person - Result
Person 1 - Positive
Person 1 - Resistant
Person 1 - Type A
Person 2 - Slight Positive
Person 2 - Susceptible
Person 1 - Strong Positive
Person 1 - Recommendation
Person 1 - Negative
Person 1 - Not necessary
Person 4 - Negative
And so on. Sadly, I cannot alter the properties of this legacy data.
What I need to do is query this table to get a single row for each person, with a concatenation of their results in field 2.
Is this even possible?
Many, many thanks to anyone who can offer advice.
I have a table of results I need to query. It is badly designed. It holds test results for individuals, where there can be a variable permutation of results.
Like this:
Person - Result
Person 1 - Positive
Person 1 - Resistant
Person 1 - Type A
Person 2 - Slight Positive
Person 2 - Susceptible
Person 1 - Strong Positive
Person 1 - Recommendation
Person 1 - Negative
Person 1 - Not necessary
Person 4 - Negative
And so on. Sadly, I cannot alter the properties of this legacy data.
What I need to do is query this table to get a single row for each person, with a concatenation of their results in field 2.
Is this even possible?
Many, many thanks to anyone who can offer advice.
