[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