General discussion
December 5, 2002 at 06:20 PM
icekoool

Filter single column in a recordset

by icekoool . Updated 23 years, 9 months ago

I created a recordset in Visual Basic 6.0 consisting of 2 columns. How to clone this recordset so that the cloned recordset consists of a single column only having distinct record(s)?

eg: Original Recordset has 2 columns(fields) as:

Item WareHouseCode
—- ————-
CMT WHS1
CMT WHS2
PKG WHS1
PKG WHS2

The resultant recordset should give me only one colummn with distinct values. As in this case
Cloned Recordset:

Item
—-
CMT
PKG

This discussion is locked

All Comments