Combining multiple records into one (denormalising)

[pez]

Hi,

I've been landed a task in Access , for which I would be really appareicated of some help. No one in the office has a clue unfortantly.



I have a table as below, with a structure similar to:

Person ID| Contact 1|
1 xxx
1 yyy
1 zzz
2 aaa
2 bbb


For reporting purposes, it has been requested to change the structure so that it appears as follows:

Person ID | Contact(s)|
1 xxx;yyy;zzz
2 aaa;bbb


However I dont have a clue where to begin denormalising this and would really appreciate some help.

This cant be done manually, as there are over 50,000 records in the table and it is extracted from a database maintained by another application - this is purely required for reporting purposes.

If anyone could please advise what needs to be done (i've read countless articles and tried countless macro's to know avail), I would be eternally grateful.

Thank you so much

[pbaldy]

One way:

Return a concatenated list of sub-record values