Random Record fetch

[Wajid55]

Hi,

I am trying to populate an Access Form by randomly fetching one record from a table.

Is there any help avaialble about it.

Thanks

 

[PHV]

One way (SQL code):
SELECT TOP 1 * FROM yourTable ORDER BY Rnd([some numeric field])

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Wajid55]

Thanks it is working. I have a quiz DB and I am trying to loop through the questions randomly. I want to fetch questions randomly once the user clicks a confirm button.

thanks