mike Posted February 16, 2005 Share 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 Link to comment Share on other sites More sharing options...
borfast Posted February 17, 2005 Share Posted February 17, 2005 Yep, access should be able to do that without any problems Quote Link to comment Share on other sites More sharing options...
Nicholas Naime Posted February 17, 2005 Share Posted February 17, 2005 Hey, that's easy: 31. Quote Link to comment Share on other sites More sharing options...
TCH-Thomas Posted February 17, 2005 Share Posted February 17, 2005 Hey, that's easy: 31. ? Quote Link to comment Share on other sites More sharing options...
matman Posted February 17, 2005 Share 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 Link to comment Share on other sites More sharing options...
dkotchen Posted March 3, 2005 Share Posted March 3, 2005 Mike, Try this: http://www.random.org/nform.html Quote Link to comment Share on other sites More sharing options...
matman Posted March 3, 2005 Share 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 Link to comment Share on other sites More sharing options...
borfast Posted March 4, 2005 Share Posted March 4, 2005 Very interesting page!! Thanks for the link, dkotchen! Quote Link to comment Share on other sites More sharing options...
TCH-Bruce Posted March 4, 2005 Share Posted March 4, 2005 I'm off to buy a lottery ticket! Quote Link to comment Share on other sites More sharing options...
mike Posted March 4, 2005 Author Share 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 Link to comment Share on other sites More sharing options...
Pendragon Posted March 26, 2005 Share 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 Link to comment Share on other sites More sharing options...
mike Posted April 6, 2005 Author Share Posted April 6, 2005 Good point pendragon. Thanks. Quote Link to comment Share on other sites More sharing options...
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.