MS Access and expression web

[Guest]

hy all
i am trying to generate a random query to display a random record of an
access database.

i tried this one :

SELECT TOP 1 [id], [name], [short_review], [last_edit_date], [Photo_small]
From [Books] ORDER BY RND([id])

but i get the same record all the time.
i tried using the SQL command NEWID () instead of RND but ir didnt work.

any suggestions ?

thank - johnathan

 

[Douglas J. Steele]

Unless properly seeded, the Rnd function will return the same values each
time.

See http://www.mvps.org/access/queries/qry0011.htm at "The Access Web" for
how to do what you're trying to do.