Random Records selection

[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?

 

[Douglas J Steele]

See whether http://www.mvps.org/access/queries/qry0011.htm at "The Access
Web" helps.

 

[Pringle9984]

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

 

[Guest]

Thanks for your advice - this will work well.

See whether http://www.mvps.org/access/queries/qry0011.htm at "The Access
Web" helps.