Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
how rendomize records
- Thread starter ain79
- Start date
brucerichards
Programmer
Add a flag to each record, say called selected.
Open a recordset of all data where selected is false.
Get a random number based on the number of records in the recordset. e.g.
Int((MyRecordset.Recordcount - 1) * Rnd + 1)
Move through the recordset that many times, get the data and set the new flag 'selected' to true
Repeat the process until the record count is 0.
Open a recordset of all data where selected is false.
Get a random number based on the number of records in the recordset. e.g.
Int((MyRecordset.Recordcount - 1) * Rnd + 1)
Move through the recordset that many times, get the data and set the new flag 'selected' to true
Repeat the process until the record count is 0.
- Status
Similar threads
- Locked
- Question