How can i generate a random queries using access w/o redundancy?

[Rich]

I was planning to create a test generator for study using access. I did a
couple from a training lecture from microsoft office training yet some of the
sample are repeated. Thanks in advance for the assistance.

 

[Dirk Goldgar]

I was planning to create a test generator for study using access. I
did a couple from a training lecture from microsoft office training
yet some of the sample are repeated. Thanks in advance for the
assistance.

This article covers it:

http://www.mvps.org/access/queries/qry0011.htm
Queries: Create a query that returns Random records