? INT(1000 * RAND( ) + 1)>>>Instead of using 1000 in the equation above, use 999. The +1 could give you 1001, if RAND() returns 1 which it could.
>>lnRandMin = 1 >>lnRandMax = 1000 >> >>? INT((lnRandMax - lnRandMin) * RAND( ) + lnRandMin) >>Correct?
lnRandMin = 1 lnRandMax = 1000 ? RAND((lnRandMax - lnRandMin) * RAND( ) + lnRandMin,0)> though I'm not convinced rand() returns 1.0