I am making a database for work. It includes all employees. I need a script to randomly pick a person. Easy no problem, I am using "Int(Random*Status(CurrentFoundRecordCount))+1" then goto that record. My boss just threw into the loop that he wants it weights. All employees will have a rating 0-3. If an employee is 3 that person should be picked more frequently than someone with a 0 rating. How in the heck can I pull this off? I am stumped. Sample code would be great! Thanks for the space.

This method does it in two steps. It picks a record randomly on an equal weight basis, and then does a coin flip based on the employees' weight factor to decide to accept or reject the record. If rejected, it repeats with a different randomly chosen employee.

Fields:

gRandomRecord - global number;

gWeight - global number, 4 repetitions, each rep contains a number in the range 0 to 1, the higher the number, the higher the probability of being chosen. If you use values of .25, .5, .75 and 1.0, you should get a linear weighting.

Script:

Loop