Can I query a list of cities?

[Southern at Heart]

my table [tbleName] has 500 records, of names, cities, etc. How do I make a
query that will give me a list of the cities, from the field [City], without
duplicates?
There will be lots of duplicates, but I just need a list of the cities
without any duplicates, (sorted if possible, too)
thanks,
Southern@Heart

 

[Allen Browne]

Use DISTINCT in the query, e.g.:
SELECT DISTINCT City FROM tbleName ORDER BY City;

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...