How to select a given number of random records in a query. 1

[stotzc001]

I have a database that is used for testing purposes. What I want to do is create a select query that would pick 100 questions at random from a table of about 400 records. However, I have been unable to find any function withing Access for selecting random records. Any Ideas?

 

[jfgambit]

Create a Public Funtion:

Public Function RndRecords(sngNuma As Single) As Single
Randomize
RndRecords = Rnd
End Function

Save it with the name basRandom

In a Make table query add the fields you want in the new table and RndRecords([Name of your Pimary Key]) in the Top Values combobox from the toolbar enter 100. Run the make table query and enjoy the results

HTH
"I know what you're t'inkin', ma petite. Dat Gambit... still de suave one, no?"

 

[danvlas]

Select Top 100 FieldList From YourTable Order By Rnd(QuestionID);

It will give what you want...dynamically...

Good luck




Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html