Random Selection of records in a query

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
 
D

David F Cox

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"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Real 10 random records 7
Random Function for Selecting Records 3
Returning a random selection 2
how to select a random item from a field 1
Random selection - multiple criteria 4
multiple iterations of same query 5
random selection of records 1
Random Selection of Records 5

Top