Discussion Locked

Access 2000-Random lists

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Is it possible to create a random list from an Access Database? I need a list that reflects a "random" 10% of our population once a month until all names have been chosen. The source list would change as new names are added. Don't know where to begin.
Thanks for your help

5 replies

by donq

Of course it's possible but this is a "project", not a 500 point question. Create a database where "people" are identified by an AutoNumber (Primary Key)generator and use the random number generator to report 10% of current entries between zero andmax.

This discussion is closed to new replies.