Random sampling of data

  • Thread starter Thread starter jjheberle
  • Start date Start date
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!
 
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.
 
Also look up help on the Access RND command. It will select random number for
you like RND([5]), RND([100]), RND(.5]), etc
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Making a query that isolates records with the latest date 2
Losing Records 7
Query by form with 3 parameters 1
Help on Counting and grouping distinct records 3
Return Random Sampling from Query 2
Update query to sum field from another table 4
Trying to pull same names from 2 tables 3
Parameter query with Start/End Date problem 7

Back
Top