Hi all

I'm using DMX with an Access database and ASP. When you create a recordset, you have the option to sort it ascending, descending or not at all. Is there a simple way to create a RANDOM sort order? One that will produce a different looking list each time a page (with a repeat region) is called?

I have tried various forums for help, but am getting nowhere!

Thanks in anticipation,

Regards

Chris

This article might help you solve it

sqlteam.com/item.asp?ItemID=8747

Thanks - but that's one of the sources I've looked at already, and I coldn't get it to work with Access.

Cheers

Chris