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