Concatinating Column Values to a Single Row

Question

For Example:

Color
_____
Green
Blue

output:

Green, Blue

(I'm using ms access 2007)

Answer 1

Here is the mysql's group_concat equivalent in access

http://www.rogersaccesslibrary.com/forum/generic-function-to-concatenate-child-records_topic16.html