how do I find a random record in an Access 2003 table or query?

[Guest]

I want to build a query or macro that will return a random record from a
table or another query.

 

[Dirk Goldgar]

I want to build a query or macro that will return a random record
from a table or another query.

See this article from the Access Web:

http://www.mvps.org/access/queries/qry0011.htm