Jump to content

Random number for a subset help


This topic is 8476 days old. Please don't post here. Open a new topic instead.

Recommended Posts

This is the problem. Quiz Database. I have one database that stores several different cateogories of questions. Once I find the subset of questions, I need to randomly pick a certain number of questions for a test. When I tried it, the randomly picked questions are from the whole database not just the subset(category) of questions.

I am thinking I need a field to mark as the found set and then have the random number generator pick from that marked set. But how?

Thanks in advance for any help!!!

Link to comment
Share on other sites

Create a new field called RandomNo. Suppose you want 10 random questions out of the subset.

Start with RandomNo cleared to 0 in all records.

Select your subset.

Using Replace or a loop, set RandomNo to a random number (surprise!) in all records in the subset.

Sort on the RandomNo field to randomize the set.

Now, if you want say 10 questions out of the subset, use a loop to omit records until there are only 10 left

code:


show all records

replace [RandomNo, calculation = 0]

# select your subset here

.

.

.

# randomize

replace [RandomNo, calculation = Random]

# sort on the RandomNo field

sort [RandomNo]

go to record/request [first]

loop

exit loop if status(currentfoundcount)<11

omit record

end loop


Link to comment
Share on other sites

This topic is 8476 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.