Unique values in a recordset

[Zygor]

I need a memory jog.

A long, long time ago...in a galaxy...

no. Really. I remember being able to create a recordset that eliminated duplicate values. Since I am not using a query I cannot use "select distinct..."

I thought there was another method, like creating a group that would not allow dups. It threw an error and allowed you to skip adding in the dup value.

Does this ring a bell to anyone?


Thanks

 

[Zygor]

I remmebr now. It is a collection. Thanks

 

[PWise]

you can use

Select distinct Field1,Field2,.... from Queryname