Query to merge matching data

[kmullins76]

I have a table that is populated with demographic info (ZIP, State, City, County, etc.). In multiple instances I have duplicate ZIP codes because there is more than one city within the ZIP. Another column tells me exactly how many cities are within that particular zip code. What I am trying to do is write a query that will identify these anomalies and remove the extra rows and combine all the cities only column into one row keeping all the original data in that row. The only difference in the duplicate rows are the city name, the rest of the data is exactly the same.



Something along the line of:
=IF[ZIP match then merge city separated by commas…


Thank you inadvance for your help.

[June7]

A query alone can't do that, need VBA function. Review: http://allenbrowne.com/func-concat.html

A column with an aggregate value such as the count of cities is not a good design. That count should be calculated when needed.