Select 20 Random Records In Query

[jereece]

I have to review 20 reports each month for quality check. I have a query that lists the reports completed within the past 30 days. Is there a way to filter this query to show only 20 random records?

If there is no way to do this, can you suggest some way of doing this so that it's impartial? For example I don't want to select the first 20 of the month because everyone will catch on and wait late in the month to post their report. Normally about 70 reports are completed in a month.

Thanks,
Jim

 

[ajetrumpet]

Jereece,

Take a look at posts #30 and #31 in this thread:
http://www.access-programmers.co.uk/forums/showthread.php?t=141780&highlight=randomizing

My example is OK, but it is incredibly complicated.

Wayne's example is much easier, and simpler to follow. He uses a stored query.

 

[Mile-O]

Here's another one; http://access-programmers.co.uk/forums/showthread.php?t=42409

 

[ajetrumpet]

That's a good success story Mile-O.