ms-access, group by with concatenation

touf · Jun 4, 2008

Hi,
I've the folowing table
Country City
===== ====
Canada Montreal
Canada Toronto
Canada Ottawa
USA Newyork
USA Chicago

I like to get the folowing result:
Country Cities
===== =====
Canada Montreal, Toronto, Ottawa
USA Newyork, Chicago

Is this possible with a query??
thanks

Jeanette Cunningham · Jun 4, 2008

touf,
it's not an intuitive sort of thing to do.
There is a sample database that does this on this web site

http://rogersaccesslibrary.com/Othe...Generic Function To Concatenate Child Records'

Jeanette Cunningham -- Melbourne Victoria Australia