Multiple Criteria

[nnightwolf]

hello guys,
i have a database which has many fields pretty much the same (such as cities).
the are 148 records and 10 cities(which are repeated). I want to put the cities in a combobox but 1 each time not all of them.Can you help me plz

[samycbe]

on the query select distinct keyword for avoiding the duplication

example

select disstinct(cityn ame) from <table>

and fill the database in combo