A Way To Non Volatile Randoms?

Nov 15, 2004

Ok, I have a formula that looks at a date and a status. If the status reads "unsatisfactory" I generate a random number between 30 and 60. If not then it finishes the remainder of the statement. The problem I have is every time I load the record to check on it the number changes. Is there a command or script that anyone knows of to make this random portion non-volatile? The statement I am currently using is below.

=IIf([Combo68]="Unsatisfactory",[SF Exercise]+(Int((60+1-30)*Rnd()+30)),IIf([Resource Type]="AA&E",[SF Exercise]+365,IIf([Resource Type]="Major Funds",[SF Exercise]+365,[SF Exercise]+1470)))

Thanks in advance
Narack

View Replies


ADVERTISEMENT

Generating Randoms

Dec 30, 2004

I dont know what to call my problem but it's not much for experts, but too much for noobs like me. I've been trying to generate a random output in one of my forms which will get it's data from one of the tables that i made (Ex. frmForm1 will generate random data from Table1, and the fields are "Name", "Age", "Sex", etc.).. i've tried doing Randomize but it doesn't work. Pls advice, and thanks to whoever will give solution to this..

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved