top values on a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report that counts the number of errors, and I need to show the top
5 errors. I don't know how to sort it , because I'm counting them on the
report. They each have a value of one, and I'm just adding them. Any ideas?
 
If all you want to show on your report is the top five error, you use a
select query as the record source for your report that will return only the
top five errors. Look in the SQL manipulation section of Help for the SQL
TOP statement. Maybe it will give you some ideas.
 

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

A03 - count in report footer gives me #Error? 0
Limit results on report 9
Count Function (conditional counts) in Reports 3
How do I create a Top 5 percent report? 5
counting records 0
Help with Iif on Report 4
HOW CAN I COUNT ALL THE GROUPS IN A REPORT 1
Sort report by sum of counts 4

Back
Top