• Selecting Random Records

    Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » Selecting Random Records

    Author
    Topic
    WSroberta
    AskWoody Lounger
    May 4, 2001 at 1:59 pm #355699

    Is there any way you can make a random selection of say 50 records from a database?

    Reply | Quote
    Viewing 0 reply threads
    Author
    Replies
    • WSShane Sargent
      AskWoody Lounger
      May 4, 2001 at 5:41 pm #525151

      Roberta:

      There sure is; check out the Rnd( ) function as well as the Randomize statement in Access help. If you have questions, post back.

      A note of caution: I started to develop an app for my company to use for conducting random drug tests of its commercial drivers. After chatting with the folks in HR, we decided to use a 3d party product to minimize our legal liability. I’m not sure that this particularly applies to you, but… 2cents

      Reply | Quote
      • WSd_rasley
        AskWoody Lounger
        May 5, 2001 at 1:05 am #525218

        This is one thing that I was wondering about. Say that I wanted to generate a random list of 100 out of 1000 records, using a Rnd() function. Rnd() is just that – random. Therefore, does there exist the potential that I might end up with ~90 unique records, and some duplicate records, for the total of 100? If so, how can this be avoided? (A first thought would be to query the results of the random selection, grouping & counting records, and redo if the record count doesn’t work out right… but this is rather ponderous.)

        Switching roles from IT staff to Auditing staff, I would be interested in using some sort of random record selection process to pull lists of transactions to audit. However, I would need some assurance that the selection process worked efficiently with no potential for duplication.

        As a side note: I strongly agree that the potential legal liability must be considered wherever a random selection may have additional repercussions.

        Reply | Quote
        • WScharlotte
          AskWoody Lounger
          May 5, 2001 at 2:45 am #525221

          All the Rnd() function does, once you pass it a seed value, is generate a pseudo random number. If you sort on that number and use a top values query to give you the top 100, that should produce 100 random records. The only way you might get duplicates is if your underlying recordset contains duplicate records, which means you didn’t design something properly in getting to this point. If you use a Select Distinct in the underlying query, there should be no possibility of duplicate records.

          Reply | Quote
    Viewing 0 reply threads
    Reply To: Selecting Random Records

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums

    • Recent Topics

    My Profile

    March 2025
    S M T W T F S
     1
    2345678
    9101112131415
    16171819202122
    23242526272829
    3031  

    Remembering Woody

     

    Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.

    Mastodon profile for DefConPatch
    Mastodon profile for AskWoody

     

    Home • About • FAQ • Posts & Privacy • Forums • My Account
    Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts

    Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.