mike Posted February 16, 2005 Posted February 16, 2005 Hi TCH gang. I though maybe I could get some ideas from you folks. I have a client that has around 40 employees and he wants a program to input the employees into that will allow him to click a button and get random employee numbers for drug testing. Does anyone know of such a program? Can it be done in Access? Any ideas appreciated. thanks. Quote
borfast Posted February 17, 2005 Posted February 17, 2005 Yep, access should be able to do that without any problems Quote
matman Posted February 17, 2005 Posted February 17, 2005 Yeah, just post to your favorite web forum and ask people for any number between 1 and 40. Human minds are way more random than any computer could ever hope to be. Quote
dkotchen Posted March 3, 2005 Posted March 3, 2005 Mike, Try this: http://www.random.org/nform.html Quote
matman Posted March 3, 2005 Posted March 3, 2005 That is a cool page -- if you bookmark the result you can just go right to your "random-number-of-the-day". Here it is for 1-thru-40: http://www.random.org/cgi-bin/randnum?num=...=1&max=40&col=5 Quote
borfast Posted March 4, 2005 Posted March 4, 2005 Very interesting page!! Thanks for the link, dkotchen! Quote
mike Posted March 4, 2005 Author Posted March 4, 2005 Great page. Thanks. However I am still looking . My client wants to have the random number generator incorporated into his database of employees so that he can just click and get 3 or 4 numbers of employees for random drug testing. Quote
Pendragon Posted March 26, 2005 Posted March 26, 2005 Great page. Thanks. However I am still looking . My client wants to have the random number generator incorporated into his database of employees so that he can just click and get 3 or 4 numbers of employees for random drug testing. <{POST_SNAPBACK}> Don't forget that it will need to 'tag' the numbers it picks, so that it doesn't pick them again next time. Otherwise, you may end up with a handful of employees that never get picked, or some that always get picked. You need to come up with a method that is both random and fair, or the employees will resent the testing even more than they already do. Or, you could go by SSN.. since there are only 10 (0-9) numbers and 12 months, you could randomly pick say, 8, and all SSN's that end in 8 get tested, if there are none that end in 8, run again until you get at least 1 hit. Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.