[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