pat amaral
New Member
- Joined
- Jul 22, 2011
- Messages
- 1
I'm building a database to run scale modeling contests for the group I belong to here in Colorado. I'm using Access 2007. One of the tables I'm working with contains a list of the judges. These judges will be assigned to teams of 3. I want the database to automatically assign the team numbers for me. The table consists of five fields. JudgeID (the Primary Key) and JudgeName are the only fields of any importance. The remaining fields are only storing information about national/local club memberships.
I want to build a function that will take all the records in the table, divide the list into groups of three (teams), then evenly distribute a team number to each record. Let's say I have 15 judges on the list. Since this creates five teams, each judge will be assigned a team number between 1 and 5. I'm assuming this will have to be built using a query to get the job done.
I'd like to structure this function so that it doesn't matter how many records are in the table. If we have 41 judges, Access should be able to create 14 teams (one with two members) and then assign a team number to each judge, ranging from 1 to 14. Later in the competition, the teams will each be allocated several model catagories to judge.
Do you have any ideas on how I can pull this off? Although I've used Access a bit (a VERY little bit), I'm having trouble wrapping my head around this one. I'd appreciate any help you could give me.
I want to build a function that will take all the records in the table, divide the list into groups of three (teams), then evenly distribute a team number to each record. Let's say I have 15 judges on the list. Since this creates five teams, each judge will be assigned a team number between 1 and 5. I'm assuming this will have to be built using a query to get the job done.
I'd like to structure this function so that it doesn't matter how many records are in the table. If we have 41 judges, Access should be able to create 14 teams (one with two members) and then assign a team number to each judge, ranging from 1 to 14. Later in the competition, the teams will each be allocated several model catagories to judge.
Do you have any ideas on how I can pull this off? Although I've used Access a bit (a VERY little bit), I'm having trouble wrapping my head around this one. I'd appreciate any help you could give me.
