Recent content by leo002000

Hi, I just created a query with the "Expr1: Rnd(Now()" in the end column/field, this generates a random number, but also creates that same number for all the other records/rows? so every student has a random number of "0.301948010921478" what am i doing wrong?

Dear all, Many thanks for all your advice and comments. I'll give it a go and let you know how i get on. I think your totally correct in the way you suggest randomizing the data and then kind of accepting it's outcome, thus accepting that enough variety has been created in the groups.:)

Hi, I would like to be able to randomize student names into groups of 10, from a simple text file import. The text file would have the full name of the student and would be imported into access. I would then like to randomize those students (170) into groups of 10... 17 groups with 10...