Good great people!


I have a list of students stored in a recordset (access db). I need a vba code that:

creates a random [/B]list of students based on the recordset BUT without duplicates and PROVIDED that each student shall appear in the list.

Thanks and Best Regards

You can add a random order to a SQL query as you grab the recordset.
See sql - Random sorting query Access - Stack Overflow

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

Thanks for your kind effort. But, I need to do this from within word VBA itself.
Sorry for disturb

Hi, I've played around your idea. It works fine now. Thaaaaaaaaaaaaaaaaanks