How to select random names from within MS Access database

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

Guest

Good Afternoon,

I'm trying to determine a way to select objects (names) from an access
table to generate a report. It's be nice if, a select query would permit you
to specify a quantity of items to be selected. Can anyone assist?
 
SELECT TOP X YourFieldNames, ...
Replace the "X" with the quanity of records you want.

If your table has an autonumber field then you can use a calculated field to
simulate a random number.
Right(Left((4.6345679/ [AutoNUM]) *10,000)5),3)
Sort it ascending.
 
Back
Top