Autonumbering-Assigning a team number

message from =?Utf-8?B?Sm9obiBCb3phcnRo?= on 5 May 2004
I have a long list of participants that I want to assign a team number between 1-16. I have a field "Team Number" that I would like to be able to go through my table and do an update query to assign consecutive team numbers. Does Access have a function that will allow you to do this?

Thanks, John B.
 

Archived message: Autonumbering-Assigning a team number (Microsoft Access)
 
Note: To make this discussion more readable on the page the original messages have been edited to remove most of the references and quoting.