Random Records selection

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am building an Access app for someone, and want to be able to select
records one at a time at random from a table. The primary field is an
AutoNumber field (sequential). Unlike Excel, it seems Access doesn't have a
"Randbetween()" function. Is there any function I can use to select a record
at random?
 
Have no idea if this will work in Access, but in MySQL you can use th
following query

select * from links order by rand() limi
0,

I'm not sure if Access has the 'rand()' function or not but it's wort
a try
 
Back
Top