Search results

Thank you Arnelgp for your attempt. But i'm afraid it does not solve my problem. (or: what query exactly would provide the result set below?) What I am looking for is a query (or VBA procedure) that produces (set, giver, receiver): 1, m1, f1 1, m2, f2 1, m3, f3 2, m1, f1 2, m2, f3 2, m3...

Hi Arnelgp, Thank you very much for your effort... You asked : So what u r saying is the system will pick the pair and will continue to be paired to the second round.? We only have to consider one round here. In this round, three man give massage to three woman, one on one. There are 6...

Hi Jdraw, The possible combinations need to be bundled into sets. If a man M1 gives a massage to a female F1, he cannot massage another woman at the same time. Also F1 would not available to receive a massage from another man. So if a pair M1F1 is included in a set, M1F2 and M1F3 are not...

Hi Jdraw, Thank you for your reply. A set (or setup, just another word for set) is a group of pairs. In my example of 3 men and 3 women, a set contains 3 pairs (each pair is 1 man and 1 woman). The number of possible sets is 6. I am looking for the query that generates these 6 sets, like I...

Thank you pbaldy, for your suggestion. However, I tried this before. It does provide all possible combinations of men and women. However there is no grouping the pairs into 'setups' or sets. These are unique sets of pairs that are valid in such a way that these sets contain only pairs of men...

Hi, I am organizing a day where men massage women (round 1) and vice versa (round 2). In this example I will only focus on the first round, using 3 men and 3 women (in real, there are 6 of both sexes). The men (m1, m2, m3) give each of the women (f1, f2, f3) a score, indicating how much they...

Hi, I have some experience with MS Access 2007. Used to be a programmer in 1993, but now I do it just for fun :)