Random selection with conditional

[pokchino]

hi guys am school teacher, and have a chess tournament , which needs addressing RANDOM duels between distitas schools, with 5 students per school, with the following conditions:
1. will not face each other or with schools from the same state .
2. enfrentarso between students will have the same average or the lowest difference , example: 8.85 juanito francisco vs 8.6

They can, please help me?
Thanks in advance. attachment

[ranman256]

If you have a table of tStudents: name, school, state,Avg
build a make table query: bring in tStudents table twice, DO NOT JOIN THEM.
bring down all fields from tStudents
and
bring down all fields from tStudents_1
make the table.

next run delete query where school=school_1
next run delete query where State=State_1
next run delete query where (Avg - Avg_1) > .15 (or what ever you want this to be)

then pick random records until you have all players.

[pokchino]

tabla_concurso.xlsxhello ranman :
sorry forgot to attach an example of the data table