Sample Selection from Access Tables - Urgent Audit - HELP!!!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

To whom it may concern -

I have an Access table with 78,000 records. I need to pull a random sample
of 130 records from this table based on dollar amount ( a field on the
table). The table is to large to push to Excel and use the sampling function.
How would you do this in Access, or do you have any suggestions to do this?

Thank you in advance
 
Nikhil said:
To whom it may concern -

I have an Access table with 78,000 records. I need to pull a random
sample of 130 records from this table based on dollar amount ( a
field on the table). The table is to large to push to Excel and use
the sampling function. How would you do this in Access, or do you
have any suggestions to do this?

Thank you in advance
Click to expand...

Check this link:

http://www.mvps.org/access/queries/qry0011.htm
Create a query that returns Random records
 
Back
Top