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

  • Thread starter Thread starter david.isaacks
  • Start date Start date
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
 
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.
 
Back
Top