I do not remember what is the Random function in Access but you can do someting like this.
Select *,ramdom as MyOrder from MyTable into MyNewTmpTable
Select * from MyNewTmpTable order by MyOrder into MuNewtable
Hope this help.
>Hi,
>
>I'm using Access 2k and I need to order a query randomly : so i'll never get my records in the same order.
>
>What kind of "ORDER BY" claus should I use ? Is there a "tip" to do that ?
>
>Thanks to any idea !
>
>
>Simon