I have a database which I am using to keep track of a fantasy football draft. I have 11 teams in the league thus far and would like to randomly assign each of these teams a "draft order" number. Each team must have a unique draft number and the numbers must be in the range of 1-11. I have a "Teams" table set up with the following fields:
Team As Text
DraftOrder As Integer
Is there some way I can use a query or VBA code to assign a unique draft number to each of the teams?
TOTCOM11
Team As Text
DraftOrder As Integer
Is there some way I can use a query or VBA code to assign a unique draft number to each of the teams?
TOTCOM11