I've tested out the following:

For I = 1 to 150
  lnQuesKey = CEILING( INT( RAND() * 2500) )
* Fetch the question rec with lnQuesKey as PK
Endfor

Can't guarantee that it will give every no. from 1 to 2500 (without testing it an infinite no. of times!!!) but it seems to suffice, and HAS returned 1, and nos 1-10.

HTH

Terry

PS I set "Set Decimals" to 5, so can have very small root no. to randomise, i.e. 0.0001


>hi all,
>
>i am expected to generate a question paper consisting of 150 questions from a database of 2500 questions. Further, I am supposed to generate the question paper each time someone is required to take a test by RANDOM selection of questions from the above database.
>
>Can someone please enlighten me as to how i can go about RANDOMLY selecting 150 questions each time as i do not have the slightest idea as to how to go about this task ?
>
>With sincere thanks.