Forum Discussion

Qrew Member

3 years ago

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...

Formulas and functions

reports and charts

MarkShnier__You

Qrew Legend

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
------------------------------

AnthonyMcIntyre

Qrew Member

3 years ago

Thank you for the formula, it's getting me one step closer to solving this issue!

------------------------------
Anthony McIntyre
------------------------------