-
slect an randaom number from access
we store athe image 's name inside the table , is that possible to random to select it out?
________
Trichomes
Last edited by sql; 03-06-2011 at 02:07 AM.
-
What do you mean 'random to select it out'?
-
any row in access, by only one row at a time
________
Cannabis news
Last edited by sql; 03-06-2011 at 02:07 AM.
-
You can use newid() and TOP to get a random record as
select top 1 * from sysobjects order by newid()
-
Are they available in Acess?
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|