Query to return records from each of several designations

[djpatjames]

I've created a database that combines 2 spreadsheets with 1.3 million entries each. Within these sheets are entries with several "office code" designations. What I'm trying to create, is a query that will give me 10 to 20 records from each "office code".



Can some one provide me with what to enter as criteria to return several records from each of the office codes?

Let me know if you need more information.

Thank you!

[jzwp11]

You will need a query with a subquery similar to what Allen Brown shows here on his website. Look for the heading: TOP n records per group.

I'm not sure how you will work both tables (spreadsheets) into a solution. I would recommend trying the subquery with just one table initially.