Random Selection

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chuck - 30 May 2008 13:08 GMT

I would like to design a query that pulls a random selection of records given
by an established qiery. I am not familiar with SQL so I always use the
Query Design View window to design my queries. Can anyone lead me in the
right direction?

Reply to this Message

S.Clark - 30 May 2008 19:11 GMT

http://www.mvps.org/access/queries/qry0011.htm
http://www.databasedev.co.uk/random_query.html
http://dbageek.blogspot.com/2005/02/retrieving-random-records-with-query.html

Signature

Steve Clark,
Former Access MVP
FMS, Inc
http://www.fmsinc.com/consulting

> I would like to design a query that pulls a random selection of records given
> by an established qiery. I am not familiar with SQL so I always use the
> Query Design View window to design my queries. Can anyone lead me in the
> right direction?

Reply to this Message