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

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