Group: microsoft.public.access.queries · Group Profile · Search for Random Sampling in microsoft.public.access.queries
Date: Aug 15, 2008 22:03
Also look up help on the Access RND command. It will select random number for you like RND(), RND(), RND(.5]), etc "email@example.com" wrote: I have a database that contains thousands of records but each record will have one of 300 physician ID's. I am trying to query a random sampling of 5 records under each physician ID. Any help would be awesome!