Igor,

Why don't you make the query return a distinct set?

--

HTH

Bob

"IgorM" wrote in message
...
Hi

How to get distinct items from a recordset? Let's assume I have two
columns returned from a database: countries and cities.
I want to retrieve a list of unique country names.


Kind regards
IgorM