Neil, I took our advise and looked at Rand( ) in Help (Access 2000). RAND( ): Returns an evenly distributed random number greater than or equal to 0 (zero) and less than 1 (changes whenever the sheet changes). There was no example. I am looking for a function or procedure that will take records in a table and randomize the list. I'll keep looking.
Thanks j ----- Original Message ----- From: Squires, Neil To: [email protected] Sent: Friday, September 02, 2005 9:17 AM Subject: RE: [ms_access] Randomization Function? If memory serves correct, Rand() gets you a random number. Randomize() gives you a random key string. If you don't use randomize, you will get the same numbers from Rand each time. This allows for debugging. Look Rand up in help. There should be an example. Neil Squires -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of j Sent: Thursday, September 01, 2005 5:09 PM To: [email protected] Subject: Re: [ms_access] Randomization Function? I know that rnd([field]) is a function, but I did not know I could use randomize([field]). I'll try it....can't dance or do VBA! Thanks j ----- Original Message ----- From: Squires, Neil To: [email protected] Sent: Thursday, September 01, 2005 6:02 PM Subject: RE: [ms_access] Randomization Function? Personally I would probably use Excel to do it, but if you want to do it in access, I think you could write a code block that got used the rand() and/or randomize() functions to randomly pick a number. I've written small test apps to do it before, but I don't have any handy at the moment. You can do a query or temp table to sort them. Neil Squires -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of j Sent: Thursday, September 01, 2005 4:23 PM To: [email protected] Subject: Re: [ms_access] Randomization Function? Neil, I have a list (table) of employees (750) that I want to randomize. The randomization could be by location, or employee number, etc. I hope that once I have the function I can use a query to randomize by a particular field. Thanks j ----- Original Message ----- From: Squires, Neil To: [email protected] Sent: Thursday, September 01, 2005 5:10 PM Subject: RE: [ms_access] Randomization Function? What are you trying to do? Neil Squires -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of j Sent: Thursday, September 01, 2005 1:17 PM To: *MS_ACCESS Subject: [ms_access] Randomization Function? Friends, I am looking for a function to use in a query that will Randomize an entire table...I looked in Help, but it did not Help. The records in the table will be in a random (randomize) order. (I have a query that will select random records from a table.) TIA [Non-text portions of this message have been removed] Yahoo! Groups Links SPONSORED LINKS Database mortgage software Microsoft access database Microsoft access software Microsoft access Microsoft access database training Microsoft access database design ------------------------------------------------------------------------------ YAHOO! GROUPS LINKS a.. Visit your group "ms_access" on the web. b.. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. ------------------------------------------------------------------------------ [Non-text portions of this message have been removed] Yahoo! Groups Links SPONSORED LINKS Database mortgage software Microsoft access database Microsoft access software Microsoft access Microsoft access database training Microsoft access database design ------------------------------------------------------------------------------ YAHOO! GROUPS LINKS a.. Visit your group "ms_access" on the web. b.. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. ------------------------------------------------------------------------------ [Non-text portions of this message have been removed] Yahoo! Groups Links ------------------------------------------------------------------------------ YAHOO! GROUPS LINKS a.. Visit your group "ms_access" on the web. b.. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. ------------------------------------------------------------------------------ [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
