Random Records

A

Ally Chang

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

Dirk Goldgar

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
 
A

Ally Chang

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

Dirk Goldgar

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