query returning random assortment (1 Viewer)

[casey]

Hello all...

How do I get a query to return a group of records in a random order? I know that sum, count, etc... are SQL commands that can be used on SQL statements. Is there function to arrange the results in a random order? Thanks. Hope this makes sense.

 

[Jerry Stoner]

Set a field to auto number and new values to random. Sort by that field in your query. There may be another way but thats how Ive done it in the past.
HTH