What code could you use to build a query to pull out the top 100 summed records (example, you have 1000 stores with multiple records in the table, you build a query that groups by store number, then totals a column. I need it to only show the top 100 out of the 1000 based on the highest numbers in that criteria column. Any quick suggestions?
How about using the TOP command in SQL? If you are in the query designer, there is a combo box with the word All in it. You can select 100 from the list. Or if you are looking at the SQL put in:
SELECT TOP 100 ...
The one problem is it will select the top 100 unique values. So if you are counting orders at a store and there are 10 stores with 23 orders you might end up with 109 records. You might have to add another field for it to decide which of the 10 stores to include and which to exclude.