M
Max
Hi, i am having table of Customers having 30000 records, Table Structure like
this
Month-Customer-Name
2007/01-X
2007/01-Y
2007/01-Z
2007/02-X ..... and so on
I am using ADO, using "Select * from tbl Where Customer Name like
<condition>" i am creating recordset. Now i want to use this opend recordset
as datasource and create a new recordset which will return me the "Distinct
Month Value" for the selected Customer name. I want to fill this Distict
Month value to fill combo box.
Thanx
this
Month-Customer-Name
2007/01-X
2007/01-Y
2007/01-Z
2007/02-X ..... and so on
I am using ADO, using "Select * from tbl Where Customer Name like
<condition>" i am creating recordset. Now i want to use this opend recordset
as datasource and create a new recordset which will return me the "Distinct
Month Value" for the selected Customer name. I want to fill this Distict
Month value to fill combo box.
Thanx