top values on a report

  • Thread starter Frustrated Christina
  • Start date
F

Frustrated Christina

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?
 
K

Klatuu

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.
 
Top