Filtering a data field

Author	Thread
Filtering a data field
Posted in tutorial: Searching and sorting records in a recordset from the database
· crs0000 Joined: 26 Apr 2003 Total Posts: 1	Filtering a data field Posted: 26 Apr 2003 I want to search a specific data field and filter out duplicate entries, displaying just the unique entries in that field. An example would be to search a field named "city". The results would be just a list (report) of just the unique cities entered into the database. How can I do this?? webmaster@crseelinger.com
· remerton Joined: 16 Jun 2003 Total Posts: 1	re: search a specific data field and filter out duplicate entries Posted: 16 Jun 2003 What you want is a SELECT DISTINCT cityname FROM datatable Good luck -- Ross