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

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:
UA-cam: / @599cd
or My Site: 599cd.com/THMe...
LEARN MORE:
599cd.com/Random
LINKS:
Calculated Fields: 599cd.com/Calc...
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...
Article 1: tinyurl.com/km...
Article 2: tinyurl.com/yx...
Article 3: tinyurl.com/y5...
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/Cont...
Order Entry & Invoicing: 599cd.com/Invo...
More Access Templates: 599cd.com/Acce...
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/Tech...
Consulting Help: 599cd.com/DevNet
Twitter: / learningaccess
en.wikipedia.o...
products.offic...
microsoft.com/...
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.

[@IronAngelo88]

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

[@599CD]

Found it! :)

[@videofarmerdad]

Thank you

[@599CD]

Welcome!

[@ScottFlies]

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]

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

[@linzi-yujerry6848]

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

[@599CD]

Absolutely.

[@heartstv8285]

Hi

[@599CD]

Howdy