Please disregard that question I am an idiot. I will just generate
random numbers between 1 and 15 and then multiply by 5. Sorry for the
stupid question.

-----Original Message-----
From: Morrier, Steve 
Sent: Thursday, June 10, 2004 2:54 PM
To: [EMAIL PROTECTED]
Subject: RE: MI-L Random Number Ranges....

Thanks to those who responded, now just one more question to help the
mathematically challenged such as myself......

 

How can I make sure the random value assigned is evenly divisible by 5?
For example the range of value between 5 and 150 will only be 5, 10, 15,
20 , 25.....etc

 

Thanks again.

 

  _____  

From: Ben A Greenberg [mailto:[EMAIL PROTECTED] 
Sent: Thursday, June 10, 2004 2:43 PM
To: Morrier, Steve; [EMAIL PROTECTED]
Subject: RE: MI-L Random Number Ranges....

 

Updating the column with: 

 5 + (rnd(1) * 145) should give you a random number between 5 and 150 

Ben  Greenberg 
GIS Coordinator 
NAI MLG Commercial 
262-797-9400 

 

-----Original Message----- 
From: Morrier, Steve [mailto:[EMAIL PROTECTED] 
Sent: Thursday, June 10, 2004 1:34 PM 
To: [EMAIL PROTECTED] 
Subject: MI-L Random Number Ranges.... 

 

Hi All, 

Is there a way to update a column with random numbers that fall within a

certain range? I would like to update 500+ records with a value between 
5 and 150. Is this possible? TIA 

Steve 

 

--------------------------------------------------------------------- 
List hosting provided by Directions Magazine | www.directionsmag.com | 
To unsubscribe, e-mail: [EMAIL PROTECTED] 
For additional commands, e-mail: [EMAIL PROTECTED] 
Message number: 12133 



---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 12137

Reply via email to