Random Number Generation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to have a random number generated each time I run a query that is called from a report. I need this number to mix up the sort order of a list of people that would otherwise always be either first or last in the report so it would need it to change each time the query is run so I could sort on it and have a different person be first each time. Thanks
 
Put a calculated field in the query, and set its expression to this:
RandomSort: Rnd()

Then do your sort on this field.
--
Ken Snell
<MS ACCESS MVP>

TL said:
I would like to have a random number generated each time I run a query
Click to expand...
that is called from a report. I need this number to mix up the sort order
of a list of people that would otherwise always be either first or last in
the report so it would need it to change each time the query is run so I
could sort on it and have a different person be first each time. Thanks
 
Back
Top