View Full Version : query returning random assortment


casey
05-15-2002, 08:54 AM
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
05-15-2002, 09:03 AM
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