SQL HELP - SELECT STATEMENT

I'm a complete newb to this so I have no idea what that means to do ... it just confused me more?

Can you explain it a little better please?

And yes, you were exactly right.  They key thing is I need to display "teamname" on specific table rows for each round.

The code above assumes that you have all five recordsets stored into arrays, so you will need those arrays. Second, it assumes that there are at least one row in each of the arrays.

The for statement creates a loop that will loop through each row in the first array (arrRound1). The mod function provides you with the remainder from dividing 2 numbers. 4 mod 3 is 1. 2 mod 2 is 0. 10 mod 3 is 1. You only want to display arrRound2 once for every 2 arrRound1, when i mod 2 = 0 arrRound2 will be displayed. Because the array rows in arrRound2 are half the value of the corresponding rows in arrRound1 you divide i by 2. Because there is no remainder i/2 should be a whole number, so the CLng isn't really needed, but I added it anyway to insure that you have an integer. The above then follows for each additional array with every array having exactly half the records of the previous one thus the you go from 2 to 4 to 8 to 16.

Then you will need to check to see that there is a row available and then check to see if the team listed in the row goes along with the team in the pairing.

If you have an array then it must have a least one row. You can not use the GetRow method when there are no rows to retrieve.