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

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

Show quoteHide quote

Security warning when opening a file
Patch problem Access 2003 (SP2)
I have created some sort of User level security that I cant remove! Please help...
Printing Problem
Help: Access 2003 not reading the signatures
Set Start up Security to not show Tool Bars and now i can't get in
In a shared database, can the administrator boot users
Getting "Not a valid password" when modifying Access 2000 queries...
Change "AllowFullMenus" for admin users only at startup
The Ultimate Bittorrent Cheat