vendredi 14 août 2020

Multiple unique random number generation ms-access

I want to generate X number of unique random numbers in a range and insert those numbers into a new table The number of samples "X" will be defined when entered into a field of a table.

at the moment I have

SELECT Int((End_Sample_No-Start_Sample_No)*Rnd()+Start_Sample_No) AS RandNum

I am stuck on working out how to making more than 1 random number and ensuring that if I do make more than one it is not already used.

Any suggestion or direction is appreciated.




Aucun commentaire:

Enregistrer un commentaire