The information in this article applies to:
SUMMARY
Novice: Requires knowledge of the user interface on single-user computers.
MORE INFORMATION
To shuffle the records in a table, create a query based on that table and
all its necessary fields. Add a calculated field that contains the Rnd()
function with a positive integer variable parameter. Then, sort by this
calculated field. Every time you evaluate the query, the records will be
shuffled.
Expr1:Rnd(1) the query calculates the Rnd() function once and then repeats the same value throughout the recordset. To avoid the repetition, create a calculated field with a variable numeric argument. For example, if the table has an Employee ID field, you can use the following expression as the variable numeric argument: Expr1:Rnd([Employee ID]) If the table does not have a numeric field, write an expression such as the following to calculate a numeric value based on any other field: Expr1:Rnd(len([First Name])) The Rnd() function ignores the expression, but the variable nature of the argument forces the query to evaluate the Rnd() function for every record. REFERENCES
For more information about returning a random record please see the
following article in the Microsoft Knowledge Base:
Keywords : kbusage QryGnrl |
Last Reviewed: April 9, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |