View Full Version : Access report with random number


hew
04-06-2000, 07:36 AM
I want a report pulling information from one table. The table has 4300 records, but I only want a random sample of 56. One of the fields that I am pulling over is a numeric field that is a file number. I want to use this as reference for when I generate my random numbers. How do I do this?

Val
04-07-2000, 08:23 AM
Try using a query that uses the rnd function. EX:Rnd([Numeric_field]+1)
Then sort the query by the new field and change the SQL Statement to Select Top 56.