Automatically Assign students to groups using access

[mqbsshlw]

Hi All,

I am trying to automatically allocate 200 students to 60 groups, based on gender so there is a good mix.

smaller example so you can see what I mean:

group 1, group 2, group 3

bert
rob
jane
mike
lorraine
jim

bert in group 1, rob in group 2, jane in group 1, mike in group 3, lorraine in group 2, jim in group 1 and so on.


Normally this is done with pen and paper, or cut and pasting names from excel into another sheet, but there has to be a better way.

If anyone could help, I would be very grateful

[damonreid]

I personally would use excel for this task.

Simply put the following code into a cell and copy beside all the names.

=ROUND(RAND()*60,0)

This should give an even distribution... completely random though.