Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Oct 23, 2011 06:13 PM by hans_v
Oct 22, 2011 01:26 PM|LINK
I am using ACCESS DB, I would like to select a random record row from my database. It doesn't work from the SQL statment I found "SELECT column FROM table ORDER BY
Any idea? Thanks.
Oct 22, 2011 03:49 PM|LINK
SELECT TOP 1 * FROM myTable ORDER BY Rnd(-10000000*TimeValue(Now())*[id])
Oct 22, 2011 11:42 PM|LINK
It is a long time ago, but I remembered this thread, but when I read it again, I noticed something regarding another thing:
I know that a bunch of functions within Access are not supported by the Jet provider. If you try Replace() for example, you get a function not supported error. The way round this is to create a saved query and call that in the same way as a stored proc in SQL
This is not true. When executing saved queries, they can only contain functions that are supported in Jet, otherwise they will raise an error also.
Oct 23, 2011 01:45 PM|LINK
I tried. I have 16 records in database, but it keeps showing me 2 of the cords. Do you know what the problem is?
Oct 23, 2011 06:13 PM|LINK
Do you know what the problem is?
Not if you don't show us what exactly you're doing?