MarkShnier__You
2 years agoQrew Legend
Re: Lists and Random Functionality
I have this in my bag of tricks to generate a Random number. If you really cared how random it was you would have to run your own statistical test I suppose. Since it is based on the record ID then you have to decide if that works for your process because of course this pseudo-random number will never change for a particular Record ID
ToNumber(Right(ToText(Int([Record ID#]*9973/127)),4))
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------