Randomize DB Records

I have this ms access table

ID Data
1 Apple
2 Orange
3 Banana
4 Mango

How can I display the records in random order in every page load?

Re: Randomize DB Records

"MA P" wrote in message
news:uP3uppAVHHA.4764@TK2MSFTNGP05.phx.gbl...
>I have this ms access table
>
> ID Data
> 1 Apple
> 2 Orange
> 3 Banana
> 4 Mango
>
> How can I display the records in random order in every page load?

http://www.adopenstatic.com/faq/RandomRecord.asp

--

Mike Brind