Random Generator

[Guest]

Can anyone tell me how to create a random generator that will pull from a
table and display specified fields in a form?

 

[Dirk Goldgar]

In

Can anyone tell me how to create a random generator that will pull
from a table and display specified fields in a form?

It's not completely clear to me what you're after, but this might be a
step in the right direction:

http://www.mvps.org/access/queries/qry0011.htm
Queries: Create a query that returns Random records

 

[missinglinq via AccessMonster.com]

I had this code squirreled away; I don't usually hold hacks unless I've
tested them, so I think it's viaable.

This SQL will return 10 random records

SELECT TOP 10 Rnd(Len([PrimaryKeyField])) AS Expr1,YourTable.PrimaryKeyField,
YourTable.Field1,YourTable.Field2,YourTable.Field3
FROMYourTable
ORDER BY Rnd(Len([PrimaryKeyField])) DESC;

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com

 

[Dirk Goldgar]

In

I had this code squirreled away; I don't usually hold hacks unless
I've tested them, so I think it's viaable.

This SQL will return 10 random records

SELECT TOP 10 Rnd(Len([PrimaryKeyField])) AS
Expr1,YourTable.PrimaryKeyField,
YourTable.Field1,YourTable.Field2,YourTable.Field3
FROMYourTable
ORDER BY Rnd(Len([PrimaryKeyField])) DESC;

You must arrange to execute the Randomize statement at some point before
calling the Rnd() function, if you want the result to reasonably random.