Ok I have this very simple statement<BR><BR>Sqldetails = "SELECT transaction, username FROM Activity " & _<BR>"WHERE username = '"& Session("username") & "' "<BR><BR>Ok the issue is this:<BR><BR>Lets say I have 4 records in my tables. <BR><BR>2 of those records have the same "transaction" field and the other 2 also have the same "transaction" field. <BR><BR>When this statement loops, it acutally loops 4 times because of the 4 records. But what I really want it to do is only loop twice because the field "transaction" only has two values. <BR><BR>Make any sense?