×
×™× ××™
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
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