AnsweredAssumed Answered

Sorting records into groups

Question asked by JaneFlower on Feb 16, 2015
Latest reply on Feb 18, 2015 by philmodjunk


Sorting records into groups



My database manages attendees at camp for teens.  I need to breakdown all the attendees into groups of 7 or 8 and mix them up so there’s even distribution of boys and girls, a good mix of ages and ensure that people from the same places aren’t likely to be in the same group.

Is it possible to create a script, or some other type of sorting mechanism, that will create randomised lists based on this criteria?  If so, how would I start constructing it – for example, what functions should I look into?

Many thanks.