How do I randomly select records in Access?

[Guest]

I need help randomly selecting records in Access but I am not familiar enough
with the program to even write a query. How can I do this using the drop down
menus or selections?

 

[Ed Robichaud]

Close your eyes, and scroll the datasheet? What are you trying to do by
selecting a random record and does it really have to be "random" or just
some non-sorted pick?
-Ed

 

[John Nurick]

This is a frequently-asked question. If you go to www.groups.google.com
and search for
"random query" group:microsoft.public.access.queries
you'll find many previous answers.

 

[Douglas J. Steele]

Take a look at http://www.mvps.org/access/queries/qry0011.htm at "The Access
Web"