January 12, 200719 yr I need to generate a random number between 1 and 28. How do I do this and if it is over 28, how do I make it go back and try again? thanks
January 12, 200719 yr Hi Vandy Here is a calculation I use, I have amended it to your requirements. 1 + Round ( Random * ( 28 - 1 ) ; 0 ) This will generate a random number between 1 and 28 each time, you can have this in a calc or as a set field script step. I hope this does the trick. Orlando
Create an account or sign in to comment