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.
Thank you!! I was looking or this answer all over the internet!!
Found it! :)
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!
I've got something like this coming up in a future video. Stay tuned...
Is it possible to make this into a button that let users select how many questions they want to generate?
Absolutely.
Thank you
Welcome!
Hi
Howdy