Just discovered how to randomze results from a QUERY.

E.G

Select TOP 100 *
from tblCDs
ORDER BY Rnd(CDID)

Works a treat. Get me 100 random CDs from my collection.

BUT..what I would like to do is try and ensure the spread across the CDs is as even as possible;

i.e 10% Rock, 10% Dance, 10% Classical etc.

Any ideas would be great...

Thanks