Access report with random number

  • Thread starter Thread starter hew
  • Start date Start date
H

hew

Guest
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?
 
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.
 

Users who are viewing this thread

Back
Top Bottom