ASPForums.Net RSS Feedhttp://www.aspforums.net/Handlers/RSS.ashxLatest additions to the content that appears on ASPForums.Net(c) 2019 www.aspforums.com. All rights reserved.SQL Query to SELECT records in Random Order in MS Access database<p>Try following in MS Access</p> <pre class="brush: sql">SELECT TOP 1 Quotes,Author FROM QUOTES ORDER BY rnd() </pre> <p>&nbsp;</p>https://www.aspforums.net:443/Threads/111820/SQL-Query-to-SELECT-records-in-Random-Order-in-MS-Access-database/https://www.aspforums.net:443/Threads/111820/SQL-Query-to-SELECT-records-in-Random-Order-in-MS-Access-database/Thu, 24 Jan 2013 00:12:51 GMTSQL Query to SELECT records in Random Order in MS Access database<p>i solved with a little edit on your code</p> <pre class="brush: vb">SELECT TOP 1 Quotes, Author FROM QUOTES ORDER BY Rnd(-10000000*TimeValue(Now())*[id])</pre> <p>and it works fine</p>https://www.aspforums.net:443/Threads/111820/SQL-Query-to-SELECT-records-in-Random-Order-in-MS-Access-database/https://www.aspforums.net:443/Threads/111820/SQL-Query-to-SELECT-records-in-Random-Order-in-MS-Access-database/Sat, 26 Jan 2013 00:52:23 GMT