Lists and Random Functionality
Hi everyone, I am new to QB so these questions could have simple solutions so I figured I would post them. I am currently uploading 100K+ in entries from excel and want to select a random 1000 from th...
Forum Discussion
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
------------------------------
Thank you for the formula, it's getting me one step closer to solving this issue!
------------------------------
Anthony McIntyre
------------------------------
------------------------------
Anthony McIntyre
------------------------------
