Can I query a list of cities?

  • Thread starter Thread starter Southern at Heart
  • Start date Start date
S

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
 
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]...
 
Back
Top