Alright, I think I have heard someone do this before with Access. I need to be able to assign 25 students per room. But these rooms will have criteria. Here are the following criteria.
9th graders - Not testing go into rooms.
10th graders - All are testing and have to go to specific rooms.
11th graders - Testers go to specific rooms and non-testers go to specific rooms.
12th graders - Go to non-testing rooms.
Is there a way to produce a generator that will go through the fields and look for the GRADE LEVEL and if they ARE TESTING or not TESTING and put them in the rooms that are identified. Example: Room 1 - 50 are for all 10th grade testers. So I want 25 students per room. Is that possible? Please advise.
Are all rooms named like that (consecutive integers)? Do all the combinations you mention result in consecutive rooms? Do you want the assignment balanced (e.g. for the rooms you mention, all 50 rooms used with students spread evenly between them) or 25 in the first room, 25 in the next room, 25 in the next until all students accounted for, even if this leaves rooms unused?
I hate trying to divine algorithms. Try this: get some index cards, write one for each student with name, grade and testing. Then, one by one, put them in rooms and explain why each student went in a different room.