Random Expressions

There are many methods for creating a set of random records. Perhaps the easiest is a simple query expression in the form

RandomExpression: Rnd([field])

where field is any value field in your bound object. You can use this expression on any value field: AutoNumber, Number, or Date/Time. Next, apply any sort order other than None to the RandomExpression field. It doesn't matter which you choose--either will work.

Running this query produces a random value (based on [field]) for each record. Sorting the RandomExpression field has the effect of sorting the records in random order.

Access Index

Main Index