Expand all | Collapse all

Random Sample

  • 1.  Random Sample

    Posted 09-19-2019 17:55
    Hi does anyone know if there is a way to have QB pull a random sample from a table of data?

    Sheri W

  • 2.  RE: Random Sample

    Posted 09-19-2019 18:30
    Typically this is done by taking every nth record based on the Record ID# and that is done using the REM function.  can you give me a specific example of the sample that you want to pull.  It is like 10% of the records or do you need 200 random samples.

    Do you need the samples restricted to a certain time period?

    For a quick answer, if you wanted every 20th record, it would be where

    REM([Record ID#], 20) = 0.

    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach

  • 3.  RE: Random Sample

    Posted 09-19-2019 18:34
    Hi Mark,  Thanks!  I'll give it  a shot.

    Sheri W