ok, i've done this before but can't remember how.<br>
I need to generate 100 unique random numbers ranging from 1-X, with X being a value enterred by the user.<br>
I thought i did this before through a query, but i can't seem to get it to work now. the formula i'm using now is<br>
<br>
Int([Upperbound]*Rnd())<br>
<br>
the problem with this is that it returns the same number 100 times, as oppossed to a different one. i know it's possible, i've done it before.<br>
<br>
thanks <p>Brian Famous<br><a href=mailto:bfamous@ncdoi.net>bfamous@ncdoi.net</a><br><a href= > </a><br>
I need to generate 100 unique random numbers ranging from 1-X, with X being a value enterred by the user.<br>
I thought i did this before through a query, but i can't seem to get it to work now. the formula i'm using now is<br>
<br>
Int([Upperbound]*Rnd())<br>
<br>
the problem with this is that it returns the same number 100 times, as oppossed to a different one. i know it's possible, i've done it before.<br>
<br>
thanks <p>Brian Famous<br><a href=mailto:bfamous@ncdoi.net>bfamous@ncdoi.net</a><br><a href= > </a><br>