Return only top 5 or 10 highest values on a Report?

D

david.isaacks

I have a query with about 132 rows. The field names are Owner & Count.

I want to have a report that only runs the top 10 from the query.

Thanks,
Dave
 
B

BruceM

You cam limit the query to the top 10. There are several ways of doing
this. You could add "Top 10" (without the quotes) after SELECT in SQL view,
or you can open the query in design view, click View > Properties, and put
the number you want into Top Values on the property sheet, or you could
select the number from the Top Values drop-down box (or type it in) on the
query design toolbar.
 
Top