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?
M P [ Mo, 19 Februar 2007 10:44 ] [ ID #1633800 ]

Re: Randomize DB Records

"MA P" <mark [at] textguru.ph> wrote in message
news:uP3uppAVHHA.4764 [at] 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
Mike Brind [ Mo, 19 Februar 2007 12:15 ] [ ID #1633803 ]
Webserver » microsoft.public.inetserver.asp.db » Randomize DB Records

Vorheriges Thema: login and logout
Nächstes Thema: Will pay for need help and occasional advise on using excel