Show values from different records in one field

[Hallgeir]

I have a table looking like this:
Code Value
1 A
1 K
2 A
2 B
2 L
2 J

I need my query to look like this:
Code Value
1 A, K
2 A, B, L, J

Can this be done, and do anyone have any suggestions on how it could be
solved?

Thanks!
Hallgeir

 

[Duane Hookom]

There is a generic concatenate function with samples at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

 

[Guest]

This is normally done using a custom function in VBA. Duane Hookum has
developed a general one that he often posts a link to. Following is the info
pasted from one of his past posts:

Check out the generic concatenate function at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

HTH, Ted Allen

 

[Hallgeir]

There is a generic concatenate function with samples at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

Thank you, Duane! I really appreciate your answer. Your concatenate function
was exactly what I was looking for and I would not in a lifetime manage to
do that fuction myself (well, maybe in a liftetime ). I also think you
raise the value of your function by showing how to use both ado and dao. I
learned much from that.

Regards
Hallgeir

 

[Duane Hookom]

Glad it helped you. I had just written the DAO code and someone else (being
helpful) provided the ADO which I then learned from and included.