Generating a query into a random order

[gary g]

All I want to do is to use my query to return a list of names in a random order. What is the secret to easily doing this? For example:

The query consists of a list of staff members by last name/first name (approx 65 names). Is there a way to have the query list these names in a totally random order each time I run the query?

 

[plog]

Do you have an autonumber primary key on the table? Let's say you do and let's say its called [StaffID], then you would add a field to your query like so:

SortOrder: Rnd([StaffID])

Then you can order by that field.

 

[gary g]

That sounds easy enough, I will try that. Thank you.