How do I retrieve a random subset of records

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mvagnier - 10 Jul 2006 19:10 GMT

I need to select a random subset of membership records for a survey. What is
the best approach to obtain a truly random (and unduplicated) subset?

Reply to this Message

Ofer Cohen - 10 Jul 2006 19:15 GMT

Check this link on "Create a query that returns Random records"

http://www.mvps.org/access/queries/qry0011.htm

Signature

Good Luck
BS"D

> I need to select a random subset of membership records for a survey. What is
> the best approach to obtain a truly random (and unduplicated) subset?

Reply to this Message

mvagnier - 10 Jul 2006 19:50 GMT

Ofer, Thank you very much for the expedient, helpful reply. I have
implemented and tested this suggestion several times, and it works
beautifully! Thank You!!

Mike Vagnier

> Check this link on "Create a query that returns Random records"
>
> http://www.mvps.org/access/queries/qry0011.htm
>
> > I need to select a random subset of membership records for a survey. What is
> > the best approach to obtain a truly random (and unduplicated) subset?

Reply to this Message