Hi, I am developing a site using DMX and Access for which i need to return a random record in a related products section. I am currently using the following sql statement

SELECT ProductName, ProductID, ProductThumbnail
FROM Products
WHERE ProductSection = 'BannerStands'
ORDER BY RND(ProductID)

Although this does seem to return the records in a random order it is the same 'random' order each time. As I am displaying the first record returned I get the same result in my page each time. I've trauled the net but can't seem to find a simple solution to this that does not involve rewriting the ASP code. If anyone can help me I would very gratefull

Try this one.
...
ORDER BY RAND()