shurmoore


I have a problem and am stuck. Pleeeeeeeeeeese could someone help me over this hurdle

Heres the scenario: I want to filter through a recordset and create an array of the records, then compare values of each column/row pair to see whether the next record has the same value as the previous. I have about seven columns of data and about 400 records.

I want to put the values of each column in its own listbox, but i don't want the listbox be populated with duplicate records--as some of the records do have the same values.

Here's example data:

sQProdByManufacturer
ProdID UPC Description Base Curve Diameter Color Sphere Cylinder Axis Add Revenue/Diagnostic BrandID ProdTypeByManufacturer ProdImageLarge CatID ProdListPrice ProdLongDesc
30572163 733905000000 ACUVUE BIFOCAL 6PK 85-900+250 8.5 14.2
-9

2 R 1 Acuvue Bifocal
4 $65.00
30572162 733905000000 ACUVUE BIFOCAL 6PK 85-900+200 8.5 14.2
-9

2 R 1 Acuvue Bifocal
4 $65.00
30572161 733905000000 ACUVUE BIFOCAL 6PK 85-900+150 8.5 14.2
-9

1 R 1 Acuvue Bifocal
4 $65.00
30572160 733905000000 ACUVUE BIFOCAL 6PK 85-900+100 8.5 14.2
-9

1 R 1 Acuvue Bifocal
4 $65.00
30572159 733905000000 ACUVUE BIFOCAL 6PK 85-875+250 8.5 14.2
-8

2 R 1 Acuvue Bifocal
4 $65.00
30572158 733905000000 ACUVUE BIFOCAL 6PK 85-875+200 8.5 14.2
-8

2 R 1 Acuvue Bifocal
4 $65.00
30572157 733905000000 ACUVUE BIFOCAL 6PK 85-875+150 8.5 14.2
-8

1 R 1 Acuvue Bifocal
4 $65.00
30572156 733905000000 ACUVUE BIFOCAL 6PK 85-875+100 8.5 14.2
-8

1 R 1 Acuvue Bifocal
4 $65.00
30572155 733905000000 ACUVUE BIFOCAL 6PK 85-850+250 8.5 14.2
-8

2 R 1 Acuvue Bifocal
4 $65.00
30572154 733905000000 ACUVUE BIFOCAL 6PK 85-850+200 8.5 14.2
-8

2 R 1 Acuvue Bifocal
4 $65.00