Pairing Question

C

Chad

I'm new to access, but I think its just what I need to use for this issue. I
am trying to generate a debate pairing info (brackets for competition). I
have a list of debators and I need to generate 3 rounds (or at least 2
rounds) of competition between two debators with certain rules holding true:
-debators from same school don't compete with one another
-same seed doesn't compete
-debators need to argue a different side in round 1 and round 2.

I've got a foundation in access that generates all the possibilities for
round 1, but I need help with the next step. Any thoughts? Thanks in
advance.
-Chad
 
P

pietlinden

I'm new to access, but I think its just what I need to use for this issue. I
am trying to generate a debate pairing info (brackets for competition). I
have a list of debators and I need to generate 3 rounds (or at least 2
rounds) of competition between two debators with certain rules holding true:
-debators from same school don't compete with one another
-same seed doesn't compete
-debators need to argue a different side in round 1 and round 2.

I've got a foundation in access that generates all the possibilities for
round 1, but I need help with the next step. Any thoughts? Thanks in
advance.
-Chad
Click to expand...

sounds like you'd have your base query for all the possibilities and
then eliminate the round 1 possibilities. so use the find unmatched
query wizard (or use a left join) between ALL and Round1, and you
should be good to go. (Makes me miss the MINUS operator, which is
available in Oracle...

SELECT ID FROM MyTable WHERE X=True
MINUS
SELECT ID From OtherTable WHERE...

and it does the set math for ya. And the SQL is very clear.
 
C

Chad

Thank you so much for your insight. All I have is the inital query which
outputs all possibilities for all the debators. The next step I need is to
generate a round 1 pairing for all debators (each debator can only be in
round 1 once, obviously). How do I setup a report/query or whatever it takes
to generate this data for me based upon all of the possibilities? After
that, then I will be able to do as you suggest for the second round.

Thanks again,
Chad
 
Top