If you would like to consolidate the records you are seeing in the list you should do a group by. When you add a group by clause to your rs it will ensure that the values that are returned are grouped by the column you reference. Here is a link to more info on this SQL statement:
sql_groupby.asp