Recordset Randomizer
Returns a recordset in proper random order. Allows subsets ie; a random ten of one hundred records, with allowance for paging of left over records. Must work in Access. Must be able to return complete 10 records - not run off end of table. Must be true statistical random to suit potential advertisers. Suggested workaround so far is to deposit recordset onto new "make table" and assign a random number to each row in the new table. Much working out for point and click DW wizards!
Read More