group_concat

[RB]

Is there a function similar to the group_concat of MYSQL
in Access.

I am trying to do something like this,

Num1 State Value
91702 DC 1
91702 MD 1
91702 MD 2
91702 MD 3
91702 VA 1
91702 VA 2
91702 VA 3


I need an output as below,

basically group by Num1 & Value

Num1 State Value
91702 DC, MD, VA 1
91702 MD 1
91702 MD 2
91702 MD 3
91702 VA 1
91702 VA 2
91702 VA 3

 

[Duane Hookom]

You have to write one or use one similar to the generic concatenate function
found at http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.
There is a sample database that shows how to use it.