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: ms_access@yahoogroups.com 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: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] Behalf Of j Sent: Thursday, September 01, 2005 4:23 PM To: ms_access@yahoogroups.com 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: ms_access@yahoogroups.com 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: ms_access@yahoogroups.com [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 Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/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/
