[AccessD] Random rows ?

Function RandomOrder(Dummy as long) as Single
    RandomOrder = Rnd()
End Function

Then use a query:
Select myNumber from myTable Order by RandomOrder(myNumber)

Remember to make a call to Randomize at some stage before running the query 


-- 
Stuart

On 22 Oct 2008 at 9:59, Bob Heygood wrote:

> 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