Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Other Forums  MS Access  Random order on refresh

Author  Topic  fuzzie Starting Member 2 Posts Posted - 2001-04-02 : 16:47:55 I have read (and tried) the various queries in the randomness section of the website...good job with that by the way. However, I am using access and cannot for the life of me figure out how to display db records in random order each time the page is refreshed. The photo gallery is at http://crimescenedivers.org/photos.asp and is purely database driven. I have tried several versions of: Select * from gallery Order by rnd() or Order by rnd(autonumb) and so on, but without avail. I just tried: ORDER BY Rnd(IsNull(autonumb)*0+1) It is random the first time, but not on page refresh. PS you can test out the results at http://crimescenedivers.org/sqltest.asp Select * from gallery ORDER BY Rnd(IsNull(autonumb)*0+1) Any help would be greatly appreciated.