Random sampling of data

J

jjheberle

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!
 
K

KARL DEWEY

It would help to know more than your database has physician ID's.
Post the table structure with field names and datatype. Post sample data.
 
G

Golfinray

Also look up help on the Access RND command. It will select random number for
you like RND([5]), RND([100]), RND(.5]), etc
 
Top