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