How to Select Random Records in Microsoft Access. Top X. Random Number Generator. Randomize.

แชร์
ฝัง
  • เผยแพร่เมื่อ 2 ส.ค. 2024
  • In this video, I will show you how to select any number of random records using a simple query in your Microsoft Access database.
    Brad from Langley, Oklahoma (a Platinum Member) asks: I'm trying to figure out how to build a form to generate random lists from our clients. We do drug testing for companies, and we have to randomly pick 20% of each company's employees for testing.
    Silver Members and up get access to an Extended Cut of this video. Members will learn how to work with random numbers using VBA. I will show a technique to make the random numbers more "truly" random based on external input instead of relying completely on the pseudo-random number generator in the computer. We'll also see how to get random numbers from a web-based API.
    MEMBERS VIDEO:
    • Random Records EXTENDE...
    BECOME A MEMBER:
    TH-cam: / @599cd
    or My Site: 599cd.com/THMember
    LEARN MORE:
    599cd.com/Random
    LINKS:
    Calculated Fields: 599cd.com/Calculated
    Access Expert 26: 599cd.com/ACX26
    Access Developer 3: 599cd.com/ACD3
    INTERESTING STUFF:
    Random.org: www.random.org
    Random.org API: www.random.org/clients/http/
    Article 1: tinyurl.com/kmbnv5v
    Article 2: tinyurl.com/yxp8camd
    Article 3: tinyurl.com/y5o46928
    COURSES:
    FREE Access Beginner Level 1: 599cd.com/Free1
    $1 Access Level 2: 599cd.com/1Dollar
    FREE TEMPLATE DOWNLOADS:
    TechHelp Free Templates: 599cd.com/THFree
    Blank Template: 599cd.com/Blank
    Contact Management: 599cd.com/Contacts
    Order Entry & Invoicing: 599cd.com/Invoicing
    More Access Templates: 599cd.com/AccessTemplates
    ADDITIONAL RESOURCES:
    Donate to my Tip Jar: 599cd.com/TipJar
    Get on my Mailing List: 599cd.com/YTML
    Contact Me: 599cd.com/Contact
    TechHelp: 599cd.com/TechHelp
    Consulting Help: 599cd.com/DevNet
    Twitter: / learningaccess
    en.wikipedia.org/wiki/Microso...
    products.office.com/en-us/access
    microsoft.com/en-us/microsoft...
    KEYWORDS:
    microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, random numbers, rnd, randomize, pseudo random numbers, random number generator, top 10 records, top x records, top 20%, truly random numbers, vba timer function, seed, unique, each row, 3d6, mouse xy, mouse move
    QUESTIONS:
    Please feel free to post your questions or comments below. Thanks.

ความคิดเห็น • 10

  • @IronAngelo88
    @IronAngelo88 2 ปีที่แล้ว +1

    Thank you!! I was looking or this answer all over the internet!!

    • @599CD
      @599CD  2 ปีที่แล้ว

      Found it! :)

  • @ScottFlies
    @ScottFlies 2 ปีที่แล้ว

    Need some help. I need to import a bunch of Excel files into Access. In Excel, we have several columns with cells that need to have multiple lines like:
    Line1
    Line2
    Line3
    In one cell (entered into Excel with alt-enter)
    After importing into Access, we get:
    Line1Line2Line3
    In the Access field.
    Do you already have a video for keeping (or fixing) the line formatting on import?
    Thanks!

    • @599CD
      @599CD  2 ปีที่แล้ว +3

      I've got something like this coming up in a future video. Stay tuned...

  • @linzi-yujerry6848
    @linzi-yujerry6848 2 ปีที่แล้ว

    Is it possible to make this into a button that let users select how many questions they want to generate?

    • @599CD
      @599CD  2 ปีที่แล้ว

      Absolutely.

  • @videofarmerdad
    @videofarmerdad 6 หลายเดือนก่อน

    Thank you

    • @599CD
      @599CD  6 หลายเดือนก่อน

      Welcome!

  • @heartstv8285
    @heartstv8285 2 ปีที่แล้ว

    Hi

    • @599CD
      @599CD  2 ปีที่แล้ว

      Howdy