Question Locked
How to query in Access 07 to pull a random data sample?
0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have two tables: Auditor table that contains auditor information and a AuditDetail table that contains information detailing the audit. They are linked by Auditor Number. I need to pull a list of 5 detail records PER Auditor. I have tried the RND function but I just get 5 records total. I cannot figure out how to get it 5 per auditor.