Concatenate the values from the same column in multiple records

[JLuis Estrada]

Hi!!!

I need your help! I got a table with something like this

ID Number
1 123-4567
1 654-9876
1 357-9510
2 963-8521
3 789-4561

And I need a query (in fact, it gonna be a subquerry) that return me
something like this

'123-4567, 654-9876, 357-9510'

What exactly need is concatenate all the records in one single text value
to put it on a report.

Is this possible?

JLuis

 

[Duane Hookom]

One method uses code. There is a generic concatenate function with sample
usage at http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

 

[JLuis Estrada]

Is this the only way to do that??

One method uses code. There is a generic concatenate function with sample
usage at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

 

[Guest]

You can also check this out:
http://www.mvps.org/access/modules/mdl0008.htm
Not sure if it is the same code as on Duane's web-site.

-Amit
===================

 

[Duane Hookom]

The solutions are very similar. Mine might be a little more flexible.

 

[JLuis Estrada]

Tnx so much!

Let me try it and i will let u know if I got any doubt!