I have a database with a bunch of names. Then I have a query that gets me only the names of the active people. From this, I want to randomly divide them into a set number of groups (each with the same number of people). Each month I will do this so that we get to meet as many new people as possible in our fellowships. I tried the RND function based on my autonumber ID field, but it put a different amount of people in each group and it wouldn't group all the 1s, 2s, ect together on a report. Would appreciate any advice you can give.

Thanks