random selection

[boyiajas]

am having a problem of selecting 40 rows at random from a table every single time this is my code:

Set oRs = oDatabase.Execute("SELECT Top 40 * FROM Questions ORDER BY Rnd(QID)", , adOpenForwardOnly Or adLockReadOnly) 

and i also try this code not working for me: Here is the syntax (x = table, ID = field)

SELECT TOP 1 x.ID
FROM x
ORDER BY Rnd([id])*[id]*Now();

Pls Help me.....

[Mihail]

SELECT TOP n X.*
FROM X
ORDER BY Rnd([ID])*[ID]*Now();

where "n" is the number of records ( =1 or =40 )

[boyiajas]

Thanx Mihail for you concern i tried this code:

Randomize
  Set oRs = oDatabase.Execute("select top 40 Questions.* from Questions order by rnd([QID])*[QID]*Now()")

where Questions =table

My problem is the same set of question row is been selected at random at every run time

[Rabbit]

Please use code tags when posting code.

Your parentheses is in the wrong place.

select top 40 Questions.* 
from Questions 
order by rnd([QID]*[QID]*Now())

[boyiajas]

thanx Rabbit but the code is not randomizing
different row at every run time....

Randomize
Set oRs = oDatabase.Execute
("select top 40 Questions.* from Questions
 order by Rnd([QID])*[QID]*Now()")

and i also try this:

Randomize
  Set oRs = oDatabase.Execute
("select top 40 Questions.* from Questions
 order by Rnd([QID]*[QID]*Now())")

[Rabbit]

Please use code tags when posting code. This is your second warning.

First of all, your code can't possibly run. Execute is for action queries and what you have is not an action query. So when you say that it's not randomizing, I have no idea how you can even say that if the code won't even run.