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

[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

 

[Dirk Goldgar]

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

Check this link:

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