SQL Query to SELECT records in Random Order in MS Access database

Try following in MS Access

SELECT TOP 1 Quotes,Author FROM QUOTES ORDER BY rnd()

i solved with a little edit on your code

SELECT TOP 1 Quotes, Author FROM QUOTES ORDER BY Rnd(-10000000*TimeValue(Now())*[id])

and it works fine