Random Selection of records in a query

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

Guest

rIs there any way I can select 10 records randomly in query?

What should I do for that?

Any help, really appreciate.

Thank you
 
Do a TOP10 query, sort by something like RND(ABS([key]))

There has to be an argument to the RND function that varies with each record
or else the optimiser will just call it once. That argument has to be
positive otherwise the RND function will return the previous result.

"share database with more than one users"
 
Back
Top