Top 5 records in a report based on a table

[Tlewman]

Is there a way to display only the top five records in a report that it based on a table. I need to show the top 5 suppliers based on $ sales by region. I have the filter turned on and am prompted for the region number, then I have sorted by $ sales (desc). I cannot figure out how to bring back only t he top 5- I know how to make this work when based on a query- is this possible when based on a table?

 

[Joe4]

I know how to make this work when based on a query- is this possible when based on a table?

If you know how to do this based on a query, why do you need to do it based on a table? Reports can be run from queries just as easily as they can be from tables. Simply change the Control Source of your report to pull from the query instead of the table.

 

[Tlewman]

I am trying to do this without having to build the queries (there will be a bunch because I will have multiple reports based on this same table). I have a HUGE database and I am almost at my size limit ( I really need to move this to SQL but have not had the time or the expertise).

 

[Joe4]

If you are looking to return only a subset of table in your report, you have to use a query, by definition, whether you create the query directly in the Control Source or whether you build it in the Query object.

If you base the report directly on the table, you can't return a subset of the table, only everything in it. Queries, by definition, are what you use to limit/filter the results you want to return.