How do I concatenate notes entries by the same reviewer

[Steve C.]

I have a table ContactDetails. Below are the fields I need to work with.
ID,REVIEWER, SEQ_NO, NOTES

The result I am looking for is:
1 | Steve | notes entry 1; notes entry 2; notes entry 3 ...etc

In MySQL I can acheive this by:
SELECT
ID, REVIEWER, SEQ_NO, GROUP_CONCAT(DISTINCT NOTES SEPARATOR ',')
FROM ContactDetails
GROUP BY ID

Question:
Can I do something like this in Access 2003?

 

[S.Clark]

Duane Hookom's concatenate function.
http://www.rogersaccesslibrary.com/...Generic Function To Concatenate Child Records'

 

[Steve C.]

I am getting this error when I visited the site.

ADODB.Recordset error '800a0bb9'

Arguments are of the wrong type, are out of acceptable range, or are in
conflict with one another.

/Otherdownload.asp, line 32


Thanks,
Steve

 

[Douglas J. Steele]

Try again. It worked fine for me just now.

 

[Steve C.]

I get the same error. I even cleared the caches and still got the same error.

 

[Steve C.]

Tried a different computer and still received error. Also tried to use
FireFox to see if it will work, still resulted in an error.

 

[Douglas J. Steele]

Odd. I just tried again, and it's still working fine for me.

 

[Steve C.]

Will you please resend me the link.

Thanks,

Steve

 

[Douglas J. Steele]

http://www.rogersaccesslibrary.com/...Generic Function To Concatenate Child Records'

If that still fails for you, try going to
http://www.rogersaccesslibrary.com/OtherLibraries.asp, search for the
section for Duane Hookom, and follow the link for Generic Function To
Concatenate Child Records (46 KB)