>Sorry for the confusion...row is not a column in the table there are only two cols...by row i just meant that there are 6 rows...
So the Distinct clause will run perfectly.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com