I need to make a table that includes the top 10 records from another table. I think this analogy describes it quite well.
I have 3 fields in a table;
[SalesPerson] - [OrderNo] - [OrderAmount]
Each sales person has thousands of orders. I want to use a Make Table query that inserts the top 10 (by value) orders for each and every sale person. Its as simple as that!
I want to include all three fields in the new table that will effectively be a subset of records in the first table.
I hope I have made this clear!