slect an randaom number from access

[sql]

we store athe image 's name inside the table , is that possible to random to select it out?
________
Trichomes

[rmiao]

What do you mean 'random to select it out'?

[sql]

any row in access, by only one row at a time
________
Cannabis news

[skhanal]

You can use newid() and TOP to get a random record as

select top 1 * from sysobjects order by newid()

[rmiao]

Are they available in Acess?

[MAK]

check this out

http://www.alvechurchdata.co.uk/accrandom.htm

you could use rnd function to get the random number and then query the rows that match or close to match the random number and display that record