how to get random records from an access database in asp?

[djp]

how to get random records from an access database in asp?
I just want the sql query.

 

[SpiderTip]

select * from table order by field rand()