View Full Version : How to select x random records


mmitchell
06-20-2005, 09:05 AM
I need to select 200 random customers from my table, how can I do that?

Table: tblCustomers
PK: CustID

Bat17
06-20-2005, 09:41 AM
A quick search of the forum will retun quite a few relevant threads, including this one
http://www.access-programmers.co.uk/forums/showthread.php?t=54284&highlight=random+records

Peter