"Sum" Text when Grouping by in Query

[RocketDude]

Is it possible to "sum" text values when using the "group by" functionality?
My data looks like

Category 1 Category 2 Category 3
Name Name2 Name3
Name Name2 Name4
Name Name2 Name5

And I want to get something like this:

Category1 Category2 Category3
Name Name2 Name3, Name4, Name5

TIA,

 

[Duane Hookom]

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

 

[RocketDude]

Duane,

That is exactly what I am looking for. Thank you.

It's weird, I searched the Access 2003 help for "concatenate" and it did
find the function. But it must be in there, because your queries work.

Cheers,

--
Matthew

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