Access 2003

[Peter T]

Hoe do I select 4000 random records from a database containing 46000 entries?
What's the SQL for the query? Ta.

 

[Joan Wild]

In the Queries section at www.mvps.org/access you'll find
'Create a query that returns random records'