Randomly select records based on multiple criteris

[jmccullough]

I am trying to develop a elementary school competition database and one of the options the users would like is to randomly generate teams from the registered students. The divisions would be grade 3 against 4, 5 against 6, and 7 against 8. They would also like to have 10 students per team and each school represented only once or twice on each team and with an equal or close to equal number of male and female representatives per team.

I have already been able to generate the teams with 10 player from different schools but I'm not sure how to equal out the male and female students, any suggestions or help/direction would be greatly appreciated.

I'm using Access 2007. I apologize if this is not the correct forum to place this.

Thanks for any replies.

 

[ajetrumpet]

have you checkout my randomization code in the code repository here? there is an array shuffler you can use if you're astute with vba programming...

 

[jmccullough]

Adam, thanks very much for the quick reply and code offer but I'm definitely not good with code, looking for a much easier route if that is possible.

Thanks again.

 

[ajetrumpet]

Adam, thanks very much for the quick reply and code offer but I'm definitely not good with code, looking for a much easier route if that is possible.

Thanks again.

if you post up your database here, i might be able to help you out with it. not sure what you need, but i could probably lend a hand...

 

[jmccullough]

That would be awesome!! I will try and post within the next day or so.
Thanks so much.

 

[jmccullough]

Adam, sorry for the delay at posting my db but was on vaca for a few days. I've used to select Case to assign teams, there is probably a more efficient way to do this but I'm not sure how. I've got the students onto teams but now is there a way to make sure that grade 3 plays against 4 and 5 against 6? and also to even up the ratio of male/female students is
close per team?

Any help or direction you can provide will be greatly appreciated.

Thanks again.