| | |
|
|
|
Random Records |
|---|
| message from =?Utf-8?B?QWxseSBDaGFuZw==?= on 12 May 2004 |
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 replied to =?Utf-8?B?QWxseSBDaGFuZw==?= on 12 May 2004 |
"Ally Chang" <anonymous@discussions.microsoft.com> wrote in message
news:F8CF3680-422F-410A-AAE3-6664D90625AF@microsoft.com
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
|
| =?Utf-8?B?QWxseSBDaGFuZw==?= replied to Dirk Goldgar on 12 May 2004 |
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 replied to =?Utf-8?B?QWxseSBDaGFuZw==?= on 13 May 2004 |
"Ally Chang" <anonymous@discussions.microsoft.com> wrote in message
news:C384528A-8812-42D7-B243-B58E013A7885@microsoft.com
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".
|
|
Archived message: Random Records (MS Access Error Message)
