Unicity of place names

[Rumoer]

I have an access table with zipcodes. In this list there are numerous codes with the same place name for example "Amsterdam". But i like to refer to "Amsterdam" not numerous times, but just once, making "Amsterdam" a unique name in that column. As the same for all the other place names, a unique name in that column. How can i accomplish that?

[orange]

It seems you will have to select which zipcode you want to represent Amsterdam.
There are a lot of zipcodes within Amsterdam, just as there are many zipcodes for New York City, Toronto and/or London.

[Rumoer]

It is possible in a query. That is what i am looking for. Done it in the past, but can't remember how i did it.
Can think of something like; making a new column and give every place a specific number, but then i have to go through all of them and that is not what i want.
There must be an easier way.

[orange]

What is your final objective?

According to info at http://www.geopostcodes.com/Amsterdam
it appears there are 89 distinct postal codes for Amsterdam.

They all represent some part of Amsterdam.

I attached a jpg of the 3rd postal code listed, but how will you pick the one you want to represent Amsterdam?

[John_G]

You can use a totals query, and group by the city name, but if you do that, you can't have the zip codes too.

What exactly is it that you want the query to do?

[June7]

Is this for a combobox RowSource?

DISTINCT keyword will also provide list of unique city names.

SELECT DISTINCT CityName FROM Cities ORDER BY CityName;