Can access generate random data?

[pete1982]

I have an access table with only 1 field. It is a list of names

Can a query be built that would sort the list into a random orde
every time it runs

 

[Dirk Goldgar]

I have an access table with only 1 field. It is a list of names.

Can a query be built that would sort the list into a random order
every time it runs?

Yes, easily -- and I'll tell you how if you'll explain your "Bump"
message.

Oh, okay, have a look at this article, and post back if you don't see
how to adapt it to your needs:

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