ms-access, group by with concatenation

[touf]

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]

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