T
TSLAdmin
I have an Access database with 20,000 records. Let's say they are product
sales. Each sale has a geographic region. I'd like to be able to show the top
10 selling items (by value) in each region. I can sort my data in a report to
show the sales by product in descending order of value, but it runs to 700
pages! How do I just filter the top ten highest value items and put the
remainder as a single line item?
Thanks for your advice.
sales. Each sale has a geographic region. I'd like to be able to show the top
10 selling items (by value) in each region. I can sort my data in a report to
show the sales by product in descending order of value, but it runs to 700
pages! How do I just filter the top ten highest value items and put the
remainder as a single line item?
Thanks for your advice.