combining several records into one

[Jenny]

Hi! Suppose I have a table with two text or memo fields, say Country and
City:

[Country] [City]
Belgium Antwerp
Belgium Brussels
Belgium Ghent
Estonia Tallinn
Finland Helsinki
Netherlands Amsterdam
Netherlands The Hague
Poland Gdansk
Poland Warsaw
Spain Barcelona
Spain Madrid
Sweden Gothenburg
Sweden Stockholm

I'd like a query that combines or merges all cities in each country into one
single record, for example like this:

[Country] [Cities]
Belgium Antwerp, Brussels, Ghent
Estonia Tallinn
Finland Helsinki
Netherlands Amsterdam, The Hague
Poland Gdansk, Warsaw
Spain Barcelona, Madrid
Sweden Gothenburg, Stockholm

Can this be done?

 

[Duane Hookom]

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

 

[Jenny]

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

Many thanks, Duane! It took me a while to figure out how to use your
concatenate function in my own database, but now that I have, it does
exactly what I need.