Query to select 20 random records

[jereece]

As part of my job, each month I have to select 20 problem report resolutions and grade them on quality. Typically we have about 100 problem report resolutions per month. Is there a way I can use a query to return a random selection of 20?

Thanks,
Jim

 

[CraigDolphin]

Maybe this link will help http://www.fontstuff.com/vba/vbatut02.htm