[AccessD] Random rows ?

Mark A Matte markamatte at hotmail.com
Wed Oct 22 15:36:19 CDT 2008


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/



More information about the AccessD mailing list