Dino has attended:
Access Introduction course
Access Intermediate course
Access 2003
How do i merge information in a row given that they have the same index ?
Example:
Index Info
1 A
1 B
2 C
3 A
4 D
-------------
Result i would like
-------------
Index Info
1 A, B
2 C
3 A
4 D
Still in two columns, but Info with common index have been concatenated.
RE: Access 2003
Hi Dino, thanks for your query. We are currently awaiting input from one of our advanced Access trainers on this issue, who will be in the office on Wednesday so if you don't mind waiting there should be a more detailed response then.
Many thanks and apologies for the delay,
Anthony
RE: Access 2003
Dear all,
any news with regards to this request ?
RE: Access 2003
Hi Dino,
We have a trainer working your post and they should have a response within 24hrs.
Our appologies for this delay.
Regards
Richard
RE: Access 2003
Hi Dino
Thanks for your question
First let me apologize for the delay in responding to your post.
I have spent some time investigating your requirement, and regret that I can find no way to solve the problem using standard queries.
The obvious solution would be to create a VBA procedure that would go through the record set a row at a time and create the various concatenated strings in an Array. The precise details of this solution would take some figuring out, and is unfortunately beyond the scope of this forum.
It is possible that we could provide some assistance on a consultancy basis. I will pass this information over to my colleague who will contact you shortly
Regards
Stephen
