I hope someone has an easy solution to my problem. I have an Access97 database set up to pull a random 5% of records from a table that is refreshed daily. I have a table called Random_claims_audit with 3 fields: claim number, examiner initials (different initials each day), and last date updated. Currently, I have this query set up to pull the random 5% sample:
SELECT TOP 5 PERCENT Random_claims_audit.[Claim Number], Random_claims_audit.[Examiner Initials], Random_claims_audit.[Last DateUpdated], Rnd([claim number]) AS RandomEx
FROM Random_claims_audit
ORDER BY Rnd([claim number]);
This works great, but only pulls 5% from the whole table. I need to pull a random 5% for each distinct examiner [examiner initials], and I’m just not sure how to go about this.
Thanks!