I have approximately 300 students from 15 different schools and would like to assign them to teams of 10 students per team with possibly only 1-2 students from each school on the same team. Can this be done with a totals query/subquery of some sort?



Any help or assistance is greatle appreciated.