Surely, you are already querying the database to get a recordset? What I am
saying is to change the query to only return distinct records.

--

HTH

Bob

"IgorM" wrote in message
...
Its probably me not being too specific. I don't want to query the database
to restrict connections to database.

I've been thinking about dumping values from a recordset to a collection
and using the values as a collection key too. But is there a better way to
do that - a buid-in unique filtering function.


U¿ytkownik "Bob Phillips" napisa³ w
wiadomo¶ci grup ...
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