Querry need help!!

[ppm]

Hi,

I want my access table have this querry result,
from this
--------------------
Item Color
A BLACK
A WHITE
A YELLOW
B RED
B WHITE
B
-------------------
To this
-------------------
Item Color
A BLACK, WHITE, YELLOW
B RED, WHITE
--------------------

Hopr someone can help!!

Thank!
Gary

 

[Duane Hookom]

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

 

[swpett]

SELECT "Black , " & "White, " & "Yellow" AS A, "Red, " & "White" AS B;

 

[gary]

Thank both!!

Gary