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

Question

in a query in my sqldatabase web i used this codeSELECT TOP 1 QuotesAuthor FROM QUOTES ORDER BY NEWIDbut not working in access database web

Mudassar · Accepted Answer

Try following in MS AccessSELECT TOP 1 QuotesAuthor FROM QUOTES ORDER BY rnd

baijuep · Answer

i solved with a little edit on your codeSELECT TOP 1 Quotes Author FROM QUOTES ORDER BY Rnd10000000TimeValueNowidand it works fine