Random Records

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

Guest

Hi,

I have a table of 13,000 records with fileds of either Date or Text type (No numeric fields). I need have choose 5000 records randomly from this table. Can anyone give me any idea of how to randomly choose 5000 records from a table? I am pretty novice here with Access but have to deal with this problem. Thanks in advance!
 
Ally Chang said:
Hi,

I have a table of 13,000 records with fileds of either Date or Text
type (No numeric fields). I need have choose 5000 records randomly
from this table. Can anyone give me any idea of how to randomly
choose 5000 records from a table? I am pretty novice here with Access
but have to deal with this problem. Thanks in advance!
Click to expand...

The article in the link below explains how to build a query to return a
set number of randomly selected records:

http://www.mvps.org/access/queries/qry0011.htm
 
Thanks for your quick response Dirk! In my table, all of the fields are mostly text fields and no numeric field or primary keys. Should I substitute "question" in the Select query with "mytextfield"?
 
Ally Chang said:
Thanks for your quick response Dirk! In my table, all of the fields
are mostly text fields and no numeric field or primary keys. Should I
substitute "question" in the Select query with "mytextfield"?
Click to expand...

Using the method Joe Foster suggested in that article, it really doesn't
matter what type of field you choose. So yes, you would use your own
field name in place of "question", just as you would use your own table
name in place of "mytable".
 
Back
Top