A Way To Non Volatile Randoms?
Nov 15, 2004Ok, 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