[AccessD] Random rows ?

If you already have your 2 milllion records...and want a random sort...or what appears to be a random sort...pick another field...lets say first name as an example...and sort descending on the 3rd character?   Mid([firstname],3,1)

Just a thought.

Good Luck,

Mark


> From: bheygood at abestsystems.com
> To: accessd at databaseadvisors.com
> Date: Wed, 22 Oct 2008 15:29:50 -0700
> Subject: Re: [AccessD] Random rows ?
>
> You are so right.
> I was hoping to modify the table I had already created which already
> contained the values I needed, just not in a random order.
>
> Thanks again,
>
> Bob
>
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, Lambert
> Sent: Wednesday, October 22, 2008 2:16 PM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] Random rows ?
>
> Not so. :-)
>
> Using a random automnumber is just a variation of Gustav's GUID idea. You
> said you needed to *create* a table, so everything will be a new entry.
>
> The table will have two fields, the autonumber, and the one that holds the
> 0000001 - 2000000 data values.
>
> So just run the 2,000,000 iterations of a loop adding records to the table
> and then sort it by the autonumber field, which will scramble the order of
> the 2mil records.
>
> Lambert
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bob Heygood
> Sent: Wednesday, October 22, 2008 5:07 PM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] Random rows ?
>
> That would only then work for new entries.
> And, I would have no control over the limits (I need 1 to 2000000).
>
> Thanks for responding.
>
> Bob
>
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte
> Sent: Wednesday, October 22, 2008 1:36 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Random rows ?
>
>
> Why not use an autonumber field...set the "New Value" property to random???
>
>
>> From: bheygood at abestsystems.com
>> To: accessd at databaseadvisors.com
>> Date: Wed, 22 Oct 2008 09:59:25 -0700
>> Subject: [AccessD] Random rows ?
>>
>> Hello to the list,
>>
>> I need to create a table of one row that looks like below:
>>
>> 0000001
>> 0000002
>> 0000003
>>
>> 2000000
>>
>>
>> I have had no problem so far.
>>
>> But the client wants the table output to be random. Like:
>>
>> 1114453
>> 0000022
>> 2000000
>> 0048941
>> And so forth. And of course no repeating rows......
>>
>> Any thoughts??
>>
>> Bob
>>
>> --
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>
> _________________________________________________________________
> When your life is on the go-take your life with you.
> http://clk.atdmt.com/MRT/go/115298558/direct/01/
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com

_________________________________________________________________
Want to read Hotmail messages in Outlook? The Wordsmiths show you how.
http://windowslive.com/connect/post/wedowindowslive.spaces.live.com-Blog-cns!20EE04FBC541789!167.entry?ocid=TXT_TAGLM_WL_hotmail_092008