Randomizing Query Results

[BomberMan2K]

Hi,
I'm having an issue with randomizing an ACCESS query results.
I have an index of people, which I want to show in random order each time the page loads (the page is written in ASP of course).
I've tried the RND() approach - but it always returns the same result (even if I use a random key. Can't use Randomize() in ASP code so it will affect the query).
Sql Server has NEWID() function - to really randomize things, but that doesn't apply to Access DB.
Tried to construct a VB Script in the DB, but it can't be activate inside the query when being executed from ASP pages (or can it?!)

I would really appreciate any help or ideas...

Thanks guys,
Roman.

 

[BigRed1212]

How many records and fields are you talking about?

Maybe do the query, load the recordset into an array, write randomly out of the array...

 

[BomberMan2K]

I've thought about that, and even checked the options... but I guess when you pass a hunderd records or so - it will get messy on the web server.
Or even if it's only 10 records, but 1000 people watch the page - it might just crash.