How to make a top ten report in access?

V

vicrey1972

I Have a report with 30 records, but i want to print the top 3 of them, the
highest values, how cam i make it?
 
M

Marshall Barton

vicrey1972 said:
I Have a report with 30 records, but i want to print the top 3 of them, the
highest values, how cam i make it?
Click to expand...


Changing the report's record source query to a TOP 10% query
should do it. Just make sure you have the proper field's
Sort set appropriately.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2002 change report header text 0
Auto populate value from one task to another in MS PROJECT 0
Top ten values in a report 1
horizontal grouping in ACCESS reports 2
Format column widths from one table to a separate table on same page 1
Unwanted line across top of pages; how to delete? 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Top Ten 3

Top