Create a random query

[pdono]

I am trying to pull a "True" random sample from a basic
Access table. I am currently using a SQL Top function in the report. I read in an Access tip book the Top function will not generate a "true" random sample. Is there any other functions which will select a random sample from a table?

 

[tlbroadbent]

Check to solution provided at MVPS.ORG.

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

Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.