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.
