Random Records

[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!

 

[Dirk Goldgar]

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!

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

 

[Guest]

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"?

 

[Dirk Goldgar]

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"?

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".