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. -- KARL DEWEY Build a little - Test a little "jjheberle@gmail.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! >
Also look up help on the Access RND command. It will select random number for you like RND([5]), RND([100]), RND(.5]), etc "jjheberle@gmail.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! >
